find and replace shading
Hi all,
I have a document where parts of the text are highlighted or shaded in light yellow. It seems I can't use standard search and replace to replace the highlighted text.
Can anyone help me to find a way to find the shaded parts in the document?
I have a document where parts of the text are highlighted or shaded in light yellow. It seems I can't use standard search and replace to replace the highlighted text.
Can anyone help me to find a way to find the shaded parts in the document?
You can do that with the search and replace feature, but you need to use the advanced options.
- Ctrl + H
- 'More' button
- 'Format' button
- Highlight (Highlight appears under box for Find what)
- Repeat last 2 steps for Replace With box
- Use the Highligher icon in the main Word window (the pencil with ab, next to character color) and select the desired new color - select 'none' to erase.
- Replace all, or Find Next and Replace as desired if you want to keep some. * note this will change all highlighted items if you replace all, not just any particular color. (for font/text color, you can actually look for the specific color and be more granular, for backgrounds/highlight you cannot).
- Ctrl + H
- 'More' button
- 'Format' button
- Highlight (Highlight appears under box for Find what)
- Repeat last 2 steps for Replace With box
- Use the Highligher icon in the main Word window (the pencil with ab, next to character color) and select the desired new color - select 'none' to erase.
- Replace all, or Find Next and Replace as desired if you want to keep some. * note this will change all highlighted items if you replace all, not just any particular color. (for font/text color, you can actually look for the specific color and be more granular, for backgrounds/highlight you cannot).
ASKER
I have tried this already but no success
ASKER
it is not actually the "highlight" function I am looking for it is the .BackgroundPatternColor = wdColorLightYellow.
the results can be similar looking but I'm pretty sure BackgroundPatternColor needs to be searched via a macro using VB
the results can be similar looking but I'm pretty sure BackgroundPatternColor needs to be searched via a macro using VB
Deleted post.
ASKER
??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
.BackgroundPatternColor = wdColorYellow
and need to replace any highlighted text with "" (nothing).
The end goal is to count the words that are not highlighted.