View Single Post
  #1  
Old October 6th, 2014, 12:02 PM
de_0000 de_0000 is offline
Member
 
First recorded activity by OfficeFrustration: Sep 2014
Posts: 5
Default 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.