Highlight Specific Words with Conditional Formatting

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



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?