Try

=ABS(H7-AVERAGE(B7:G7))<=2

If this post helps click Yes
---------------
Jacob Skaria


"murkaboris" wrote:

Hello:

Can somebody please advise how to include a variance in conditional
formating when using average?

i.e. I'd like to highlight cells in red if the average of a range is +/- 2%
of the number (so if H7 is 24% and the average of B7:G7 is 28% the H7 cell
will be in red and if average of B7:G7 is 25%, which is within the 2%
variance the H7 cell will be in green).

Simple average worked (=H7AVERAGE(B7:G7) --- red)....but can't figure out
how to include the variance of 2% up and down from average...

Thank you.

Monika