View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Carl is offline
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%