Conditional Formatting :) ... :(

I love the concept of Conditional Formatting and I try to use it frequently but its a love/hate relationship.   Recently I upgraded from 2010 to 2016 as the new formulas (maxifs, etc) were a help i...