Macro to Change Font Color

I completed a report and I made a mistake. I want any cell that ="TYPE" to
remove the conditional formating and change to blue, bold and underline.

There are many in the report and I do not want to go through the sheet one
by one. Is there a macro I can use to do it for me?

thank you,

daniel young

If you have Excel 2002 or 2003 you can use Find All to select all cells with
the word TYPE in them and make the change one time to affect all of them.

--
Jim
"Daniel R. Young" <DanielRYoung@discussions.microsoft.com> wrote in message
news:6C529276-E2D2-4CFC-AAB7-0581D7E9021E@microsoft.com...
|I completed a report and I made a mistake. I want any cell that ="TYPE" to
| remove the conditional formating and change to blue, bold and underline.
|
| There are many in the report and I do not want to go through the sheet one
| by one. Is there a macro I can use to do it for me?
|
| thank you,
|
| daniel young

>>you can use Find All

I'm referring to the Find All option in the Edit, Find dialog. Once the
list appears you can select the ranges listed in the list box and it will
select them in the worksheet too.

--
Jim
"Jim Rech" <jrrech@hotmail.com> wrote in message
news:uGt6uPdzFHA.3924@TK2MSFTNGP14.phx.gbl...
| If you have Excel 2002 or 2003 you can use Find All to select all cells
with
| the word TYPE in them and make the change one time to affect all of them.
|
| --
| Jim
| "Daniel R. Young" <DanielRYoung@discussions.microsoft.com> wrote in
message
| news:6C529276-E2D2-4CFC-AAB7-0581D7E9021E@microsoft.com...
||I completed a report and I made a mistake. I want any cell that ="TYPE"
to
|| remove the conditional formating and change to blue, bold and underline.
||
|| There are many in the report and I do not want to go through the sheet
one
|| by one. Is there a macro I can use to do it for me?
||
|| thank you,
||
|| daniel young
|
|