colouring cell

[KHAN]

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

Thanx

 

[Dave Peterson]

You could use
Format|conditional formatting
(in xl2003 menus)

 

[Bob Phillips]

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