Forum Discussion

Copper Contributor

May 17, 2020

Conditional Formatting Bold based on words

Hi, I want to use Conditional Formatting to show the words in bold if any of the following words are in the cell (see list below). Right now, I've created a rule per word. Which means I'm going t...

excel

peteryac60

Iron Contributor

May 18, 2020

karchavez

I am interested in your solution but do not quite follow it!

In Step 2 you have the list of words in Column A. In Column C you appear to have a list or arbitrary words that do not appear to have any connection with Column A?

So when you do your formatting in subsequent steps I am sure how this relates to the words in column A that we are trying to BOLD?

Can you clarify please?

thanks

Peter

karchavez

Brass Contributor

May 19, 2020

Hi peteryac60 ,

Column C is the column to format, I put arbitrary words to ensure the formula works properly