#1   Report Post  
Posted to microsoft.public.excel.misc
Sue Sue is offline
external usenet poster
 
Posts: 285
Default variances

How do I highlight the variances (higher or lower) than my average?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Variances using formulas Carl Excel Worksheet Functions 1 February 13th 09 05:23 AM
Delta Variances by Period MrRJ Excel Discussion (Misc queries) 8 February 10th 09 08:51 PM
calculating variances in pivot tables smw2340 Excel Discussion (Misc queries) 3 April 30th 08 11:04 AM
Create Variances using Pivot Table IF Statement[_2_] Excel Discussion (Misc queries) 4 November 9th 07 06:17 PM
How to use PivotTable's to work out Variances? colinfitz Excel Discussion (Misc queries) 0 August 2nd 07 10:08 AM


All times are GMT +1. The time now is 11:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"