B
Brian Priebe
Hello,
I have a spreadsheet in which column C contains various percentages of change from the values in columns A and B. I need a conditional formula which will highlight the five greatest percentages of negative change, meaning I want to know easily which five percentages are the most negative.
EXAMPLE:
A B C
1 OLD NEW %CHANGE
2 85.00 72.00 -15.29%
3 80.20 20.00 -75.06%
4 40.00 51.00 27.50%
5 72.00 63.25 -12.15%
6 43.00 41.00 -4.65%
7 65.00 59.50 -8.46%
8 67.50 54.50 -19.26%
9 60.12 51.00 -15.17%
So, in this example, cells C2, C3, C5, C8, and C9 would need to be highlighted because they have the most significant percentage of negative change.
Thank you for your help.
Submitted via EggHeadCafe - Software Developer Portal of Choice
Making Silverlight Emulate Synchronous Requests
http://www.eggheadcafe.com/tutorial...1-c5c717c9b184/making-silverlight-emulat.aspx
I have a spreadsheet in which column C contains various percentages of change from the values in columns A and B. I need a conditional formula which will highlight the five greatest percentages of negative change, meaning I want to know easily which five percentages are the most negative.
EXAMPLE:
A B C
1 OLD NEW %CHANGE
2 85.00 72.00 -15.29%
3 80.20 20.00 -75.06%
4 40.00 51.00 27.50%
5 72.00 63.25 -12.15%
6 43.00 41.00 -4.65%
7 65.00 59.50 -8.46%
8 67.50 54.50 -19.26%
9 60.12 51.00 -15.17%
So, in this example, cells C2, C3, C5, C8, and C9 would need to be highlighted because they have the most significant percentage of negative change.
Thank you for your help.
Submitted via EggHeadCafe - Software Developer Portal of Choice
Making Silverlight Emulate Synchronous Requests
http://www.eggheadcafe.com/tutorial...1-c5c717c9b184/making-silverlight-emulat.aspx