Sorry. I gave the wrong information. What i am trying to accomplish is if
Column A has a letter value in it and there is no date value in column b,
then i want column c to have the letter "x" put in it and the cell background
color formatted to red. Additionally, if there is a letter value in Column A
and a date value in Column B, then Column C should remain blank.

"CLR" wrote:

IN M1 type this formula.......

=IF(AND(LEN(K1)=5,LEN(L1)<5),"X","")

Then, select M1, and do Format ConditonalFormatting and set Cell Value Is,
Equal To, X.....then do the format button and select PatternTab select
the red square OK OK

Vaya con Dios,
Chuck, CABGx3



"Kelly" wrote:

If a date appears in column K and not in column L how do I turn the cell in
column M red showing an X?