ExcelBanter - variances

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - variances (https://www.excelbanter.com/excel-discussion-misc-queries/240299-variances.html)

Sue

variances

How do I highlight the variances (higher or lower) than my average?

Pete_UK

variances

If you wanted to highlight them using different colours (eg red for
higher and blue for lower) then you could use conditional formatting
for this.

Hope this helps.

Pete

On Aug 20, 10:08*pm, Sue wrote:
How do I highlight the variances (higher or lower) than my average?

All times are GMT +1. The time now is 10:26 PM.