Excel Color Scales
Color Scales
Excel preset conditional formatting tools called color scales are used to highlight specific cells inside a range and show how big those values are in relation to the other values in the range.
This is the conditional formatting menu’s Color Scales section:
Color Scale Formatting Example
Use Color Scale conditional formatting to draw attention to each Pokemon’s Speed numbers.
Color Scales, step by step:
- Select the range of Speed values C2:C8
2. From the Home menu, select the Conditional Formatting icon 
in the ribbon.
3. Color Scales can be chosen via the drop-down menu.
There are twelve Color Scale choices, each with a unique color variant.
The highest values will be represented by the color at the top of the icon 
.
4. The “Green – Yellow – Red Colour Scale” icon should be clicked.
The Speed value cells will now be highlighted by a colored background:
The highest values are represented by dark green, and the lowest by dark red.
With a speed number of 105, Rapidash is the fastest, and Slowpoke is the slowest.
Every cell in the range progressively turns from green to yellow to orange to red.
It should be noted that the color formatting is based on the range’s smallest and greatest cell values.
Adding a hypothetical Pokemon with a Speed value even slower than Slowpoke, let’s see what happens:
The Speed value of 1 for the fictitious Slowestpoke is now the lowest; it is indicated in dark red.
You’ll see that the Slowpoke Speed value is now marked in orange rather than dark red.
What would happen if we included a fictitious Pokemon that was quicker than all the others?
The fictitious Fastestpoke is marked in dark green and has a speed value of 200, more than any other pokemon.
The speed value of 105 for Rapidash is no longer the maximum and is indicated with a softer green.
Observe that the other Pokemon’s Speed numbers also alter, with 200 replacing 105 as the maximum value in the range.
Note: Manage Rules allows you to remove the Highlight Cell Rules.
