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.