Color Scale is an option for Conditional Formatting in Excel. This article will explain how to create it and when to use it.
What is a color scale?
A color scale is a way to present your data with a slight difference of color in the function of the values.
It's like a heatmap for the forecast.
Immediately you visualize the highest values and the lowest values in your spreadsheet.
How to Apply Color Scale to your values
It's very easy
- Select your data
- Activate the menu Conditional Formatting > Color Scales
- Select one of the options proposed
Automatically, each cell of your document will be coloured with a colour between green (the minimum) and red (the maximum).
- The different color represents the variation of gradient value between the min and the max.
- The yellow colour represents the middle value.
Recommendation
If your data are not in connection, the color scales won't help you to visualize the scalability of your data 😕😟
In this situation, it's better to use the bars.