LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 361
Default Cell Formatting Question

I have a table like this. I would like to format the cells so that for each
row, greatest value is Green and smallest value is Red. For example, for the
first row, %90.68% would be Green, and -28.34% would be Red.

Is this possible ? Thank you in advance.

AMD 90.68% -26.43% -28.34%
A 5.83% -37.53% 41.62%
CAT 40.13% 102.05% -14.19%
FLEX 3.50% 5.38% -27.88%
GE 72.70% 30.12% 9.35%
INTC -9.30% -19.00% 4.29%
IWM 151.48% 122.37% -0.20%
WFMI -4.09% -16.18% -4.41%
MSFT 131.67% -6.19% 18.71%
QQQQ 47.24% 42.12% -0.73%
SUNW 25.60% 25.71% 13.08%
SMH 144.23% -30.65% 8.50%
TXN 46.93% 36.61% -2.77%





 
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
Conditional Formatting question (if cell = 0, wrap cell in quotes) Mo2 New Users to Excel 6 May 11th 07 11:06 PM
Another Date/Cell Color/Condition Formatting Question Millerk Excel Discussion (Misc queries) 1 March 1st 06 05:20 PM
Conditional Formatting Question - Different Cell Colors?? olimits7 Excel Discussion (Misc queries) 2 August 10th 05 04:05 PM
Cell formatting behaviour question derek Excel Discussion (Misc queries) 3 February 22nd 05 10:17 PM
Cell / Date Formatting Question when result = -0- seve Excel Discussion (Misc queries) 3 January 17th 05 02:29 AM


All times are GMT +1. The time now is 12:39 AM.

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

About Us

"It's about Microsoft Excel"