In the Mark Keyword dialog box, please do the following operations: Click Kutools > Text > Mark Keyword, see screenshot:Ģ.
Other words for highlight download#
Note: To apply these Mark Keyword features, firstly, you should download the Kutools for Excel, and then apply the features quickly and easily.Īfter installing Kutools for Excel, please do as follows:ġ.
Other words for highlight code#
If you are not familiar with the code in Excel, here, i will introduce an easy tool - Kutools for Excel, with its Mark Keyword feature, you can highlight the specific one or more keywords at once within the cells.
Note: The above codes are case sensitive. Then, in the popped out box, please enter the keywords that you want to highlight,(separate the words with a comma), see screenshot:Īnd then, click OK button,the specified words have been highlighted at once, see screenshots: VBA code: Highlight multiple keywords from text strings: Sub HighlightStrings()ĬFnd = InputBox("Please enter the text, separate them by comma:") Tips: If you need to highlight multiple keywords from the text strings, please apply the below code: And then click OK button, all the text you specified has been highlighted only within the cells, see screenshot: Then press F5 key to run this code, and a prompt box will pop out to remind you enter the text that you want to highlight only, see screenshot:Ĥ. Characters(Start:=Len(xTmp) + 1, Length:=y).Font.ColorIndex = 3ģ. VBA code: Highlight a part of text within a cell: Sub HighlightStrings()ĬFnd = InputBox("Enter the text string to highlight") Click Insert > Module, and paste the following code in the Module Window. Select the cells which you want to highlight the specific text, and then hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. To highlight only part of text within a cell, the following VBA code can help you.ġ. Highlight specific text within a cell based on other text with VBA codeįor example, I have a range of text strings, and now, I want to highlight the specific text “ Sky” in these cells to get the result as following screenshots shown: Highlight one or more specific text within multiple cells with an amazing feature Highlight one or more specific text within multiple cells with VBA code
0 kommentar(er)
