Forum Discussion
Solved
Conditional Formatting Not Consistent
I have attached a workbook with two tabs. The Good tab behaves as I would like. There are several rows of values. If the entry directly below is different, then the text is red. If the entry direc...
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.
By the way, for better readability you may simplify formulas a bit like =A4<>A16, but that's only cosmetic.