You can use conditional formatting. There are instructions in Excel's
Help, and he

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

James UK23 wrote:
If I want to change a specific type of text in a spread sheet what do I have
to do?

For example; If I want to have a figure of £5.00 in green, but a figure of -
£10 in red. How would I be able to tell Excel how to do this?

Would it be a IF formulae?

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