You can use conditional formatting to colour a cell, with up to three
conditions. For example, you could have the cell change to red if you
input the number "1", yellow if you input "2", and green if you input "3".

There are instructions in Excel's help, and he

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

Kev wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html