Apple’s Worldwide Developers Conference to kick off June 10 at 10 a.m. PDT with Keynote address
The Keynote will be available to stream on apple.com, the Apple Developer app, the Apple TV app, and the Apple YouTube channel. On-demand playback will be available after the conclusion of the stream.
The Keynote will be available to stream on apple.com, the Apple Developer app, the Apple TV app, and the Apple YouTube channel. On-demand playback will be available after the conclusion of the stream.
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
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.
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
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.
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
