![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |