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.

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.

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

"Kelly" <Kelly@discussions.microsoft.com> wrote in message
news:7C04279B-F93F-41BE-9801-A5228B5EF7C8@microsoft.com...
> 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.