Conditional Formatting with IF/OR

[SimonHughes]

Hello, I have worksheets that can range from from cells A1 to U2000 (the row count is variable). I want to conditionally format the rows from A2 down with red font if the word Fail appears in cells C2:C2000 or D2:D2000.
I should know that but cant get it right, thanks in advance for your help.

 

[Joe4]

If you select rows 2:2000, then just enter this Conditional Formatting formula (you write it as it pertains to the first row in your selection, and Excel will update it for all others):

=OR($C2="Fail",$D2="Fail")

and choose your red formatting color.

Note that you have to put the "$" in front of the column references to lock that down, so all cells in that row look at columns C and D.

 

[SimonHughes]

If you select rows 2:2000, then just enter this Conditional Formatting formula (you write it as it pertains to the first row in your selection, and Excel will update it for all others):

=OR($C2="Fail",$D2="Fail")

and choose your red formatting color.

Note that you have to put the "$" in front of the column references to lock that down, so all cells in that row look at columns C and D.

Thannk Joe, perfect, problem solved.

 

[Joe4]

You are welcome.
Glad I was able to help!