OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   Charts and Charting (http://www.officefrustration.com/forumdisplay.php?f=8)
-   -   How to do it in ms excell 2010 (http://www.officefrustration.com/showthread.php?t=1126340)

de_0000 October 6th, 2014 12:02 PM

How to do it in ms excell 2010
 
In the range E7:E14, apply a conditional format that adds a Top/Bottom Rule to
display the highest number in the range in dark green text with a green fill.
A B C D E F
X310 Region Units Sold (2011) Units Sold (2012) Increase % Increase
R01 3,605 3,853 248 6.88%
R02 3,966 3,842 -124 -3.13%
R03 3,760 4,035 275 7.31%
R04 3,777 4,063 286 7.57%
R05 3,974 3,725 -249 -6.27%
R06 3,656 3,937 281 7.69%
R07 3,664 3,875 211 5.76%
R08 3,715 3,844 129 3.47%
Total 30,117 31,174 1,057 29.29%

Regards.

de_0000 October 6th, 2014 03:10 PM

thanks.friends.google is a best friend.
Regards.


All times are GMT +1. The time now is 06:12 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
OfficeFrustration.com