4,375 questions
How to Auto Highlight a particular word a specific colour on excel for labels
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 74%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JP
0
Reputation points
Hi,
I would like to create an automation that highlights a particular word in a set colour for my labels in excel.
ie. If '7:00' displays then highlight yellow in entire document
I'm wondering whether this can be achieved through Macros, but have not found a solution yet.
Microsoft 365 and Office Development Other
Microsoft 365 and Office Word For business Windows
1,937 questions
Microsoft 365 and Office Excel For business Windows
3,888 questions
Sign in to answer