Mar 15 2021 10:13 AM
Hi. I want to check a column for certain words e.g. cat, dog, mule, chicken, horse and if the searched for word is found then I want to format it a certain way. E.G. cat (dark blue background, white text), dog (beige background, black text, and so on. How can I do that or can I do that. I know I can use conditional formatting and containing specific text option. I find the cell references get muddled over time. Is there a function which will let me look up a format depending on value? Like a sort of
if x then (background, font colour and bold or italic), if y then ...... if q then ..... and so on. Do I need some sort of named range or can I not do this? Thanks. Dennis
Mar 15 2021 10:40 AM
Mar 16 2021 01:38 AM
Thanks for your reply. In truth I'm at best an occasional user and the wishes / wants detailed in the file are more hopes I can do something rather than sound expectations!
Mar 16 2021 04:45 AM
@DennisMetro so in the file I saw how the formatting for col C got broken up but col B formatting (because it was set to the whole column) wasn't a problem. I updated all the formatting rules to apply to the entire column so hopefully that will work smoother. I only had to modify a couple rules to exclude the blank cells.
Mar 16 2021 06:06 AM
@mtarler Thanks a lot. IN the past I have had Col B break up even when the format was set to the entire column. I think that came about when I added additional events and then had to re-sort. In Col C I don't know what the modification does but I don't really need to know. Thanks a million.