In this article, we’ll learn the use of Color scales option in conditional formatting. Also, answer questions like, why we use it in our reports and its impact in our report for the better understanding.
Basically Conditional formatting option is used to highlight the specific numbers, text and characters. Also, Conditional formatting has different type of highlighters in which Color scales is the one.
Color scales make the visualization of each value very clear, the shade of the color represent the values in cell.
Let’s take an example and understand:
We have data in which we have month wise amount details of Annual Premium, Total amount received and Revenue amount. Now, we want to highlight the values with the color scale.
Follow below given steps:
Explanation: 3 Color scales calculate the 50th percentile, the cell that is highlighting with red color holds minimum (9) value, median (36) values are colored with yellow, and maximum (80) values are colored with green.
This how we can apply color scales in data.
Also, we can modify the rules according to our requirement, let’s say we want to change color formatting.
To change the color formatting follow below given steps:-
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.