Excel 2007 considers a three-color scale and a two-color scale to be completely different
visualizations. This leads to some erratic behavior when you attempt to change the color
scale pattern by using the Color Scale icon on the Conditional Formatting drop-down.
Say that you use the Color Scale icon to apply a three-color red–yellow–green visualization.
You decide to go back to the icon and instead apply a three-color blue–yellow–red visualiza-
tion. Excel 2007 is smart enough to convert the red–yellow–green pattern to
blue–yellow–red. This behavior is logical enough.
However, say that you decide to choose a visualization ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.