Conditional Formatting Hierarchy Broken

Billy Rock

Good afternoon,

It seems there is a bug of some sort with the conditional formatting for a particular sheet. Based on the picture below we have when "Done" is checked it is supposed to format the whole row and it is at the top of our hierarchy. If you have seen this before and have a solution then any help would be greatly appreciated!

Billy Rock

All the other cells that are in color involve conditional formatting as well. So it should all turn white when we check "Done"

Paul Newcome

It looks like it is working correctly. You have the font changed to green. If you wanted it to also override the cell fill, you would need to specify that in the conditional formatting rule.

Mike Wilday

Yep, leaving it transparent will allow the other rules to flow through! I hope that helps!