Conditional formatting, simple question...

K

Kelly

If an "S" appears in column K and there is not a date entered in column L I
would like for Column M to turn red with an X. Please help! Thanks.
 
T

Tom Hayakawa

Assuming Column L will contain either a date or nothing, this formula should
work in cell M1:

=IF(AND(K1="S",L1=""),"X","")

Then you would select Format, Conditional Formatting, and for Condititon 1
you would have Cell Value Is Equal To ="X". When you enter that, also click
on the Format button for Condition 1 and click on the Pattern tab. Click on
the red background, click OK and then OK and that should do it.

HTH
 
B

Biff

Hi!

You need a formula to get the "X":

Enter in cell M1:

=IF(AND(K1="S",COUNT(L1)=0),"X","")

Then conditional format if the cell contains an "X":

Select cell M1
Goto Format>Conditional Formatting
Cell value is: equal to: X
Click the Format button
Select the desired style(s)
OK out

Biff
 
Top