Conditional format based on text in same row
Solved/Closed
joshcamp
Posts
2
Registration date
Tuesday June 20, 2017
Status
Member
Last seen
June 20, 2017
-
Jun 20, 2017 at 09:26 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 20, 2017 at 01:29 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 20, 2017 at 01:29 PM
Related:
- Conditional format based on text in same row
- Format factory - Download - Other
- Saints row 2 cheats - Guide
- Marksheet format in excel - Guide
- Kingston format utility - Download - Storage
- How to change date format in excel - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 20, 2017 at 01:29 PM
Jun 20, 2017 at 01:29 PM
joshcamp, Good afternoon.
I'm glad I could help.
Have a nice day.
--
Belo Horizonte, Brasil.
Marcílio Lobão
I'm glad I could help.
Have a nice day.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 20, 2017 at 10:11 AM
Jun 20, 2017 at 10:11 AM
joshcamp, good morning.
"...I'm not sure if this would be approached as a conditional format, a simple IF function, or both, ..."
You'll need to use BOTH.
Try to use:
a) C1 --> =IF(OR(E1="Pass", G1="Pass", J1="Pass"), "Pass", IF(AND(E1<>"Pass", G1<>"Pass", J1<>"Pass"), "Fail", "" ))
b) Conditional Format
Select C column as desired
Using formula
Rule 1
--> =$C1="Pass"
--> Format: Fill color GREEN
Rule 2
--> =$C1="Fail"
--> Format: Fill color RED
OK
Please, tell us if it worked as you desired.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
"...I'm not sure if this would be approached as a conditional format, a simple IF function, or both, ..."
You'll need to use BOTH.
Try to use:
a) C1 --> =IF(OR(E1="Pass", G1="Pass", J1="Pass"), "Pass", IF(AND(E1<>"Pass", G1<>"Pass", J1<>"Pass"), "Fail", "" ))
b) Conditional Format
Select C column as desired
Using formula
Rule 1
--> =$C1="Pass"
--> Format: Fill color GREEN
Rule 2
--> =$C1="Fail"
--> Format: Fill color RED
OK
Please, tell us if it worked as you desired.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
joshcamp
Posts
2
Registration date
Tuesday June 20, 2017
Status
Member
Last seen
June 20, 2017
Jun 20, 2017 at 12:26 PM
Jun 20, 2017 at 12:26 PM
Thank you Marcílio, this worked perfectly!