Look up "Conditional Formatting" in the HELP files.

Try it out, and then post back with any questions.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Kev" wrote in message
...
I have a spreadsheet I input various letter and figures into. I want excel
to automatically colour a cell which has a certain character in so it is
clear where these appear.