In this article we will learn how to highlight the Incell graph on the basis of high score in Microsoft Excel. To solve this problem we will use Conditional formatting along with AVERAGE function.
Conditional formatting will help to highlight the Incell chart and Average function will help to choose the graph on the basis of criteria.
Let’s take an example and understand:-
We have sales data, on the basis of sales number we have created Incell chart in column C. Now we want to highlight those cell graph which is more than average number of sales to every agent.
In this query user wants to highlight those incell graphs that is more than average of sales.
Follow below given steps:-
In this way we can highlight Incell graph on the basis of criteria's in Microsoft Excel.
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.