=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