StanW

Highlight Specific Words with Conditional Formatting

Discussion created by StanW on Jan 19, 2012
Latest reply on Mar 29, 2016 by user23934

Hi

 

I have a list of about 50 key words. I would like to have each specific instance of each word highlighted (by background color or text color) wherever it occurs in a field. So I would have the contents of a field automatically looking like this (assuming 2 of the key words were "list" and "describe":

 

List at least 5 professional organizations and describe their purpose

 

I suppose this might be doable by using a Custom Function and Conditional Formatting. I have tried a couple of Custom Functions, but I could get neither to work.

 

Any ideas?

 

Thanks!

Outcomes