In my spreadsheet, I've applied Conditional Formatting and it turns the wrong color for the rule that was created. I've even tried to edit the rule by changing the "TYPE" from Number to Percent and it turns different colors, but is still wrong. See attached
Bookmarks