Have you considered using conditional formatting? You could set this up for
one cell, and then copy the conditional formatting to all the other cells
that contain the names.

GwenH

"steve" wrote:

Hello
I have a spread sheet that contains six diferent peoples names in a schedule
format throughout the workbook I would like to change each name to a
different text color with out having to change each one. I would like a macro
that would change the text of each name I select aand chage it in the entire
wookbook. so if I have the name steve inthe schedule 70 times it will go
through the spreadsheet and change every steve to a red text. (hope this
makes sense
--
Thank You
Steve