| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format =max Function
I want to highlight the highest value in a row accross multiple columns, every other column contains the value I want to reference to obtain the MAX value: A B C D E S1 20 50% 30 70% S2 30 60% 40 30% I want to highlight the 70% because it is higher than the 20% and for store 2 I want to highlight the 60% because it is higher than 30%. I want to disregard the values in column B and D. -- JR573PUTT ------------------------------------------------------------------------ JR573PUTT's Profile: http://www.excelforum.com/member.php...o&userid=31587 View this thread: http://www.excelforum.com/showthread...hreadid=515862 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format Not Working | Excel Discussion (Misc queries) | |||
| Conditional Format (month and year) = Today() | Excel Worksheet Functions | |||
| Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions | |||
| Conditional Format Titles | Excel Discussion (Misc queries) | |||
| Conditional Format With SUMIF | Excel Worksheet Functions | |||
Threaded Mode
