Conditional Formatting – Color scale

Conditional Formatting – Color scale
Last Updated on 14/08/2023
Reading time: 2 minutes

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.

Example of heatmap with temperatures
Example of temperature heatmap

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

  1. Select your data
  2. Activate the menu Conditional Formatting > Color Scales
  3. Select one of the options proposed
Menu Conditional Formatting - Color Scales

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.
Color scales in action. The colors reflect the trend between the highest and lowest 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.

The proportion of the bars is based on the values of all the cells

Leave a Reply

Your email address will not be published. Required fields are marked *

Conditional Formatting – Color scale

Reading time: 2 minutes
Last Updated on 14/08/2023

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.

Example of heatmap with temperatures
Example of temperature heatmap

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

  1. Select your data
  2. Activate the menu Conditional Formatting > Color Scales
  3. Select one of the options proposed
Menu Conditional Formatting - Color Scales

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.
Color scales in action. The colors reflect the trend between the highest and lowest 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.

The proportion of the bars is based on the values of all the cells

Leave a Reply

Your email address will not be published. Required fields are marked *