Conditional formatting
 

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.

Conditional formatting
 

=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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=518012