Changing highlight color

[Mack88]

A client has provided a large document with various bits of text highlighted with red - virtually impossible to read in print. I need help to build a macro that can search for and replace the red with yellow (or some other color). I'm a VBA newbie, so please be gentle

Thanks in advance!

 

[JGM]

Hi Mack,

Why a macro?

Just do a find and replace...

Set you favorite Higlight color on the toolbar
Open the Find/replace dialog
Use the Format option (you may have to click on "More" first), set both the
"Find" and "Replace by" to "Highlight."
Hit Replace All
Done!

If you want a macro (But, as you can see, it is a fairly fast and painless
operation!), do the above but record it with the macro recorder.

HTH
Cheers

--
_______________________________________
Jean-Guy Marcil
(e-mail address removed)

A client has provided a large document with various bits of text

highlighted with red - virtually impossible to read in print. I need help
to build a macro that can search for and replace the red with yellow (or
some other color). I'm a VBA newbie, so please be gentle.

 

[Mack88]

Hi Jean-Guy

Sometimes the answer can be as plain as the nose on your face! Thanks for giving me the solution - problem fixed

Many thanks

Mack