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
Bookmarks