How to use color scales
Activate this tool is very easy
- Select your data (it’s better if you have several rows and columns)
- Activate the following menu and select one of these options (here the second one)
Automatically, all the colors of your cells go from the green (the minimum) to the red (the maximum).
Change the value of the parameters in the row 2 to change the panel of your table.
As you can see, apply a color scales it’s very easy and your documents are nicer. But this tool is only interesting if your data are connected.
If your data is scatter without relation, apply color scales is not the most convenient conditional formatting because you can not see clearly significant values.
In this situation, the best is to use a 3 color scales with as middle color, the same color of your background (white by default).