You have to go into format_conditional formating
In all case the condition needs to be formula is not cell value is
If the first cell you apply the format to is A4 (this format can be
copied down with paste special formats to the other cells)

Condtion 1 choose green as a colour if it is true =ISNUMBER(A4)

Condtion 1 choose yellow as a colour if it is true
=ISNUMBER(SEARCH("",A4))

Condtion 3 choose red as a colour if it is true =ISTEXT(A3)

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=523579