Forum Discussion
Conditional Formatting Not Consistent
The difference here is that in Bad for red rule you applied Underline None
and for Good just skipped it
You may move Red rule in Bad sheet on second place (which is easier) or recreate Red rule with nothing for underline, and Bad becomes Good.
The difference here is that in Bad for red rule you applied Underline None
and for Good just skipped it
You may move Red rule in Bad sheet on second place (which is easier) or recreate Red rule with nothing for underline, and Bad becomes Good.
Thanks for looking carefully at this. I thought I had recreated the formatting exactly, but I obviously missed something.
One more question - the first rule says underline None and Red, but the second rule says underline Single. Should the second rule override the first, and make a single underline?
If different rules trigger the same property first one has priority. For example, if we have rules which change only one same property, background color, here
all cells will be green, and if change the order
all cells will be yellow.
In general it's better to follow "one color - one rule", or in more details, "one cell property - one rule".
In your case with one of the rules you force to remove underlines, with another one push to have them. On the same data range. First one triggers the property, rest ignore it after that.
- Thanks again.
Is there anyplace that this is documented to this level of detail, like the offsets and precedence of rules?Sorry, I don't know. But I believe it shall be something if google carefully.