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.