How to Highlight the Incell Graph

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.

image 1


In this query user wants to highlight those incell graphs that is more than average of sales.

Follow below given steps:-

  • Select the range C7:C16

image 2


  • Go to Conditional Formatting > Select “New Rules”

image 3


  • Use a formula to determine which cells to format
  • Enter the formula :- =($B7>AVERAGE($B$7:$B$16))
  • To highlight with the color, click on Format > Font > Selec the color > click on Ok

image 4


  • All the graphs will get highlighted with selected color

image 5


In this way we can highlight Incell graph on the basis of criteria's in Microsoft Excel.


image 48


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

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

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.