What is the colour scale in Excel?

What is the color scale in excel conditional formatting?

In conditional formatting color scales, allocate 3 Color scales to calculate the values in a worksheet. One color fills to represent the lowest value, 2^nd  color represents medium value and 3^rd represents the highest value. This makes it easy to see general patterns in data, especially in large data

Please follow the below images for better understanding.

Click on conditional formatting > Color Scale > Color Option.

excel conditional formatting color scale formula

When the formula applied for datasheet shows like the below image.

How do you use conditional formatting color scales

 

Also, we can change the color scale rules according to our requirement, let’s say we can change color formatting.

After applying the formula click on More rule and customize your own rules according to your work requirements.

excel conditional formatting color scales more rules