See http://www.contextures.com/xlCondFormat01.html

--
__________________________________
HTH

Bob

"KHAN" wrote in message
...
Hi, I wana have all cells having a particular text in spreadsheet
coloured
automatically.Is there a wayout?

Thanx