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, 2nd color
represents medium value and 3rd 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.
 |
| 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 |
No comments:
Post a Comment