Conditional Formatting Bold based on words

Question

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 to have 20+ rules for bolding text when all is said and done. Is there anyway to avoid that? Is there a performance hit to the spreadsheet by having so many conditional formatting rules?

Words:

metformin
trulicity
bydureon
farxiga
jardiance
glimeperide
glipizide
januvia
alogliptin

statin
atorvastatin
lovastatin
simvastatin
pravastatin

lisinopril
losartan
valsartan
irbesartan

karchavez · Answer

Hello&nbsp;onlysublime&nbsp;,Please use following steps and let me know!&nbsp;Step 1: Write the list of words in one columnStep 2:&nbsp;Select the column to format&nbsp;Step 3: Go to Conditional Formatting -New Rule&nbsp;Step 4: Select "Use a formula..."Step 5: Write next formulaThe Range inside the COUNTIF is your list and the second parameter is the first value of your column to format.If you need to add more words to the list you only need to modify your range in the formula.&nbsp;Note: You can assign a name to the range and use it inside the COUNTIF pressing F3, this step is useful if you want to put your list on another sheet inside your workbook.&nbsp;Regards!

peteryac60 · Answer

karchavez&nbsp;&nbsp;Hi&nbsp;&nbsp;I am interested in your solution but do not quite follow it!&nbsp;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?&nbsp;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?&nbsp;Can you clarify please?&nbsp;thanks&nbsp;&nbsp;Peter&nbsp;&nbsp;&nbsp;&nbsp;