| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with average formula and variance
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weighted Average of Variance | Excel Worksheet Functions | |||
| Conditional SUM for Budget, Actuals, & Variance YTD columns | Excel Worksheet Functions | |||
| Pivot Tables - Variance and Variance % | Excel Discussion (Misc queries) | |||
| Percent Variance Formula | Excel Discussion (Misc queries) | |||
| Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
Threaded Mode
