Excel color scales: Highlighting cells with color scales

Excel color scales: YOUR OBJECTIVE

The conditional formatting with excel color scales  allows you to format the values of a data range in different colors depending on how big the value is.

This learning module “Excel color scales “will show you how to visually highlight cells with color scales and what you have to pay attention to.

Excel color  scales: HOW DOES IT WORK?

The Conditional Formatting with color scales allows you to visually highlight the progression of a data range in different colors and their shades. To do so you can select between a 2-color scale and a 3-color scale. In a 2-color scale, the yellow-red scale for instance, one color represents the lowest value and the other one the highest value within the selected cell range. All other values will be displayed in a color shade between yellow and red, depending on their size.

To apply n excel color scales to a data range, select it first:

Then click the button in the Styles group on the Home tab to open the following drop-down menu:

The Conditional Formatting with color scales allows you to visually highlight the progression of a data range in different colors and their shades. To do so you can select between a 2-color scale and a 3-color scale. In a 2-color scale, the yellow-red scale for instance, one color represents the lowest value and the other one the highest value within the selected cell range. All other values will be displayed in a color shade between yellow and red, depending on their size.

To apply  excel  color scales to a data range, select it first:

 

Move your mouse pointer over the command in the drop-down menu:

 

The following submenu opens:

You can select here between the following templates:

3-Color Scales: Three different colors are used for this type of scale to highlight the data progression.

2-Color Scales: Two different colors are used for this type of scale to highlight the data progression.

Now you want to highlight the percentages in the Occupancy rate column in the 3-color green-yellow-red scale. Click the green-yellow-red option to do so:

You have added  excel color scales to the selected data range. In this case it is a 3-color scale which highlights the lowest value in red, the medium value in yellow and the highest value in green:

lowest value

medium value

highest value

HINT

Click the Conditional Formatting button on the Home tab and select the Clear Rules command to delete a Conditional Formatting.

CAUTION

Previous Excel versions do not support this Conditional Formatting feature. Color scales are not displayed when you open the file with a previous Excel version in the compatibility mode.

Did you like it? Then share it or sign up!

You can share this article with your friends or sign up for our newsletter for further information.

Leave a comment

Connect with Facebook

*

Kein Banner zum Anzeigen