 |
 | 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 / New Users / July 2007Highlight highest value in row
I have a sheet with 10 columns and several hundred rows. How do I (in Excel 2007) highlight the highest value in each row. I know I can apply conditional formatting to each row individually but this would take far to long and is impractical. Any help would be greatly appreciated. Gerry Select the whole column, and in CF change Condition 1 to Formula Is and a formula of =MAX(A:A)  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >I have a sheet with 10 columns and several hundred rows. How do I (in Excel >2007) highlight the highest value in each row. I know I can apply >conditional formatting to each row individually but this would take far to >long and is impractical. Any help would be greatly appreciated. > > Gerry I could not get this to work at all. perhaps I should explain a little more. My sheet looks like this (7 cols and first 3 rows): 1,4,6,7,8,5,9 7,4,5,3,7,8,2 5,7,3,4,6,2,1 ect I want to know the easiest way of highlighting the 9 from the 1st row, the 8 from the second and the 7 from the third i.e.the highest value in each row. > Select the whole column, and in CF change Condition 1 to Formula Is and a > formula of [quoted text clipped - 7 lines] >> >> Gerry Select A1 and do Format > ConditionalFormat, and set the conditions for Cell Value equals, =MAX($A1:$G1), and set your formatting..........then use the FormatPainter little paintbrush in the upper toolbar to copy the formatting over to the rest of the cells in the range of interest. Vaya con Dios, Chuck, CABGx3 > I could not get this to work at all. perhaps I should explain a little more. > [quoted text clipped - 20 lines] > >> > >> Gerry Hi Gerry, Assuming your data is in A1 to J600. Select all your data with A1 the active cell Set Conditional Formatting to formula is =A1=MAX($A1:$J1) HTH Martin >I have a sheet with 10 columns and several hundred rows. How do I (in Excel >2007) highlight the highest value in each row. I know I can apply >conditional formatting to each row individually but this would take far to >long and is impractical. Any help would be greatly appreciated. > > Gerry Thanks Martin, that worked a treat > Hi Gerry, > [quoted text clipped - 11 lines] >> >> Gerry
|
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.