Looking here you can modify to suit.

http://www.rondebruin.nl/find.htm


On Feb 9, 3:59*pm, johan wrote:
Hello,

Is there a VBA code to select several columns and the set several
mentioned text in another color.
For example;
I've got the columns A till Z and a lot of cells are filled with
various text.
I want to format only the written text "aaa" and "bbb" and "ccc" and
"ddd" to the color red.
Al other text in the same cell should keep their original color.
If possible, is there a maximum in columns or rows ? I want to do use
this code for perhaps 40 different text.

regards,
* *Johan.