Get instant live expert help on I need help with highlight text in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
How to highlight, in colour, part of a text in a cell
Solved by O. S. in 11 mins
I need a formula to highlight cells in a sheet having same text as in a list in another sheet. In attached file, i want to highlight cells in sheet 1 which has same text as in column B of sheet 2.
Solved by G. W. in 18 mins
I need to highlight duplicate values. But value in my column is stock as text. I tried to convert it into number by using Text to columns.... but if I do that, all my cells finish by 000... Before or after, when I highlight its highlight all the data in the column
Solved by K. C. in 21 mins
I need to create a formula which colours excel fields when the same text is found on two different tabs. For example on one sheet i have the text - BOWDOL, so when this appears on both sheets, it would highlight the field in a colour.
Solved by A. L. in 11 mins
Have issues with "Excel Track Changes" capability. Excel 365 > Review > Track Changes (Legacy) > Highlight Changes How do I change size of balloon window, or allowed length of text, or text font, "to enable seeing the entire change"? If I apply "Excel track changes" to cells with text longer than 64 characters, the change balloon truncates both the original text, and the changed text with ..... I can't see the change)
Solved by G. H. in 27 mins