Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting question (if cell = 0, wrap cell in quotes) | New Users to Excel | |||
Another Date/Cell Color/Condition Formatting Question | Excel Discussion (Misc queries) | |||
Conditional Formatting Question - Different Cell Colors?? | Excel Discussion (Misc queries) | |||
Cell formatting behaviour question | Excel Discussion (Misc queries) | |||
Cell / Date Formatting Question when result = -0- | Excel Discussion (Misc queries) |