View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sean[_15_] Sean[_15_] is offline
external usenet poster
 
Posts: 25
Default 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,