How to color the graphic & number together with conditional formatting?

[sachar]

Dear All,

With reference to the subject, please coloring, the only "above average" graphic & figures sample file is attached?

 

[tomas]

Hi

see if this works for you

 

[sachar]

Dear Tomas,

Thanks, my problem is almost solved, cannot be possible only select the rule "above and below average" formatting?

 

[tomas]

you can choose in cell G2 if you want above or below

 

[Hui]

Sachar

Can you please be more specific about what you mean by:
cannot be possible only select the rule "above and below average" formatting?

Give an example of what your after if possible

 

[NARAYANK991]

Hi ,

The problem with using the Above or Below Average rule is that the values are in column B , while you are trying to colour the graphic in column C.

You can use this rule to colour the values in column B.

If you want to colour the graphic in column C , I think you will have to use a formula.

Narayan