Conditional formatting

[Kelly]

What i am trying to accomplish is if
Column K has a letter value in it and there is no date value in column L,
then i want column M 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 K
and a date value in Column L, then Column M should remain blank.

[davesexcel]

=IF(COUNTA(K1:L1)<2,"X","")
place this formula in m
highlite cell m1 and goto to format=>conditional format
select if cell value
the next box select equals to
next box type in X
click the format
font
select the colour you want
press ok till you are out of conditional formating
try it out