

It made me realise that probably the function would not be doing what I want anyway, I checked and as I expected, it would return the color of the cell background. That's what I created: Function ColorIndex(Rng As Range)īut, then when I wanted to check if it works in Excel, I realised that in Excel there is no 'higlight the text' option at all. I found on the internet the way to sum the content of the cells if they have specific background color, and then using this thread I changed the function so that it checks for the highlight color, not background. What I would like to do is to sum the numbers from the rows that were highlighted (in only one column). The macro selects the word and turns off highlighting, and since you start typing right after the macro is complete, you end up replacing whatever word you affected.I have a table in Word. You could, though, modify the macro just a bit to make it even more valuable:Īssuming you want to remove the highlighting from a word, all you need to do is position the insertion point within the word (no need to select the entire thing), run the macro, and then start typing.

In many respects, it isn't much different than the second approach I am suggesting, using the Ctrl+Alt+H shortcut. You can assign this macro to a shortcut key, which will make it easy to apply as you are typing along. Options.DefaultHighlightColorIndex = wdNoHighlight PowerPoint has Highlight for text these days it didn’t for a long time (too long). That includes Finding highlighted text and the Find Reading Highlight of results.

The following will remove the highlighting from whatever text you have selected: Outlook uses Word to run the email editor so many Word features are available when you’re writing emails. All you need to do after selecting the text is press Ctrl+Spacebar, which removes any explicit formatting, including the highlighting.Ī fourth approach is to use a macro to remove the highlighting. This shortcut toggles the highlight on whatever text is selected, so it is a quick way to turn the highlight on and off.Ī third approach is great if you are using styles and the highlighted text doesn't have any explicit formatting (besides highlighting) attached to it. This does affect both layers, and you can immediately begin typing without the lingering highlight.Ī second approach is to use Word's shortcut key that controls highlighting: Ctrl+Alt+H.
#Text is highlighted in word manual#
One is to simply press the Delete key after you select your text and before you start typing. Hi, how do i remove the ‘pinkish’ backdrop on my wordpress texti see that the manual highlight text has a blue backdrop but i can’t get rid of the pinkish highlted text on some text that i don’t want highlighted.
/A2-HighlightinGoogleDocs-annotated-7ce2794adfe64ea0b9c64fe20ed39197.jpg)
There are a few workarounds you can try out, though. When you select some highlighted text and start typing, then you are affecting only the layer on which your text resides the layer on which the highlighting resides is not affected. The reason, apparently, has to do with your text and the highlighting being on different layers of the document. The short answer is that there is no easy way to do this. He wonders if there is a way to make the highlighting disappear when selecting and typing over a word. Since James has to do this hundreds of times a day, it gets old. To get rid of the yellow highlighting, he must select the word again and "unhighlight" it. When he then selects that highlighted word and types a new word over it, the new word appears, but the yellow highlighting remains. When James applies a highlight color (such as yellow) to a word, the background around that word turns yellow.
