 |
 | 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 / October 2007conditional format based on rank?
is there any way to use a conditional format formula to rank the numbers in column of a pivot table or a range? example: top score : cell pattern red 2nd highest: cell pattern blue 3rd highest: cell pattern yellow > is there any way to use a conditional format formula to rank the > numbers in column of a pivot table or a range? [quoted text clipped - 4 lines] > 2nd highest: cell pattern blue > 3rd highest: cell pattern yellow Use these 3 Conditional Format formulas... Condition 1 ========== Formula is: =C1=LARGE(C:C,1) Format: Pattern -- Red Condition 2 ========== Formula is: =C1=LARGE(C:C,2) Format: Pattern -- Blue Condition 1 ========== Formula is: =C1=LARGE(C:C,3) Format: Pattern -- Yellow Rick Thanx!!!!!!!!!!!!!!!!!!!!!!!1 worked purrrrrrrrfectly! |
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.