 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2007Cell 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% Select the range in question, do formula is and put =MAX($A2:$C2)=A2 where A2 is the active cell use MIN for condition 2 (I am assuming that the top is A2:C2, adapt accordingly)  SignatureRegards, Peo Sjoblom >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 [quoted text clipped - 16 lines] > SMH 144.23% -30.65% 8.50% > TXN 46.93% 36.61% -2.77% Try this, 3 conditional formats =A1=MAX($A$1:$C$1) =A1=MIN($A$1:$C$1) =A1=MEDIAN($A$1:$C$1) in each case use Formula is and choose your colour. Use format painter to drag across Mike > 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 [quoted text clipped - 17 lines] > > Try this: Assume the range of cells in question is A1:C10 Select the range A1:C10 Goto the menu Format>Conditional Formatting Condition 1 Formula Is: =A1=MAX($A1:$C1) Click the Format button Set color to GREEN OK Click the Add button Condition 2 Formula Is: =A1=MIN($A1:$C1) Click the Format button Set color to RED OK out Note that if the min and max are equal the GREEN color will be applied first. Biff >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 [quoted text clipped - 16 lines] > SMH 144.23% -30.65% 8.50% > TXN 46.93% 36.61% -2.77% |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.