Is there a way to use the 3-color conditional formatting without a gradient and just have 3 colors.
I'd like to show just 3 colors, Red, Yellow and Green based on certain criteria. I can create 3 rules (one for each color) but would like to know if it's possible to do it without having to do 3 separate rules.
I'd like to show just 3 colors, Red, Yellow and Green based on certain criteria. I can create 3 rules (one for each color) but would like to know if it's possible to do it without having to do 3 separate rules.