Experiment with Format|Conditional Formatting
Try something like Formula IS : =SEARCH("d",A1)0
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"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.