Conditional formatting, simple question...
 

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.

Conditional formatting, simple question...
 

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

"Kelly" wrote:

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.

Conditional formatting, simple question...
 

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 FormatConditional Formatting
Cell value is: equal to: X
Click the Format button
Select the desired style(s)
OK out

Biff

"Kelly" wrote in message
...
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.