Change Text Color When?
 

I have the following,

Col A Col B Col C Col D

123 James King LSF
321 Sean Smith Adecco
555 Ryan Mathis TSA

I want the color of text in colums A, B, and C, to change to RED when
anything besides LSF is entered in column D. I tried doing this through
conditional formatting but keep getting the formula wrong, or should I even
be using that method?

Thanks,

Change Text Color When?
 

Conditional Formatting is fine, highlight columns A,B,C, and in Conditional
Formatting select Formula Is from the drop down & enter
=$D1<"LSF" (Assuming that A1 is your active cell.)
and choose your formatting - red in this case.



"Sean" wrote:

I have the following,

Col A Col B Col C Col D

123 James King LSF
321 Sean Smith Adecco
555 Ryan Mathis TSA

I want the color of text in colums A, B, and C, to change to RED when
anything besides LSF is entered in column D. I tried doing this through
conditional formatting but keep getting the formula wrong, or should I even
be using that method?

Thanks,