Forum Discussion
Conditional Formatting - a column
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 ...
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.
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.