If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|