In this article, we are going to learn how to color numbers, based on specific criteria, using Conditional Formatting in Microsoft Excel.
What is Conditional formatting?
Conditional formatting is the way to highlight the cells or range in the report to make it more analyzed. For Ex: – in a report, we want to highlight the numbers of good performer so we always use Conditional formatting.
To understand how we can color the number based on specific criteria by using Conditional formatting, let’s take an example and understand:-
We have sales data in which we have City, product, Rep name and No. of sales.
In the above data, we want to highlight the numbers, which are above 90, in green color and the numbers, which are less than 90, we want to highlight in yellow color.
To highlight the cells, follow below steps:-
To highlight the number which is below 90, follow the same above 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.