software

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

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

quot;stevequot; wrote:

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

no and I wish I would have thought of that when I started the spreadsheet.
but now it is finished untill 2007 for six people every day. when I do 2007
I'll remember to do that.
but thank you for responding.
--
Thank You
Stevequot;Gwen Hquot; wrote:

gt; Have you considered using conditional formatting? You could set this up for
gt; one cell, and then copy the conditional formatting to all the other cells
gt; that contain the names.
gt;
gt; GwenH
gt;
gt; quot;stevequot; wrote:
gt;
gt; gt; Hello
gt; gt; I have a spread sheet that contains six diferent peoples names in a schedule
gt; gt; format throughout the workbook I would like to change each name to a
gt; gt; different text color with out having to change each one. I would like a macro
gt; gt; that would change the text of each name I select aand chage it in the entire
gt; gt; wookbook. so if I have the name steve inthe schedule 70 times it will go
gt; gt; through the spreadsheet and change every steve to a red text. (hope this
gt; gt; makes sense
gt; gt; --
gt; gt; Thank You
gt; gt; Steve