Font color

Giganews Newsgroups
Subject: Font color
Posted by:  - (ja…
Date: Sat, 06 Jan 2007

I have an excel file that has about 30,000 cells containing names.

How can I quickly change the font color of all the cells depending upon what
word is in the cell.

For example, is there a way to search for the word John amonst the 30,000
cells.  Anywhere the word John is found, the font color is changed to red.
Another example would be anywhere the word Bob is found, that word font
color would be changed to green.

Thank you