I selected the entire column.
Rule 8 is "contains” NJ with the selected color
Rule 9 is “contains” Philadelphia with selected color
When creating rule 10 with “contains” Baltimore with selected color I get nothing.
Little help.
MacBook Pro 13″, macOS 12.3
I see that the text is bold, which might be applied by another rule like perhaps "contains MD". Once a rule has been found to be true the following rules are ignored.
Hi MrBoston,
I managed to create 15 Conditional Format rules.
Rule Number is in Column A.
"Text contains" and the text and the Highlight result in Column B.
Column C is a test of those Conditional Highlighting rules.
Note that there is a hierarchy. For example, "Banana" in Column C follows Rule 1 ("Text contains A" > Green Fill) because the first "a" in "Banana" overrides Rule 2.
Regards,
Ian.
MrB,
Did you know that if the order of your rules is causing you a headache you can easily change the order? Just grab the handle to the left of the rule and drag it to where it needs to be.
The handle is four horizontal gray lines just below the word "Rule".
Jerry
You’re right. There was some type of overlap with the text contains. When I changed bold it changed other texts as well. I had to delete some rules and redo. Thank you.
Conditional highlighting not working on the tenth rule
