| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting based on max in range of other columns
If I have a list oif names in the A column, and various #s in columns B thru
R, and the max of those #'s is in B20. Can I conditional format any A column name that has the max # (14) in it's row. Basically I'd like to conditional format the names Steve and Billy because they're the only ones that have a 14 in their row. Thanks, A B ..... Q R Steve 13 14 11 Rick 13 7 10 Billy 12 14 9 Kurt 13 7 9 Dan 12 6 13 max 14 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Based on Colors in a Horz Range of Cells | Excel Discussion (Misc queries) | |||
| Conditional Formatting Based of Cells Based on Data Entry in anoth | Excel Discussion (Misc queries) | |||
| How to conditional format columns in a range based on | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional formatting based on date range | Excel Discussion (Misc queries) | |||
Threaded Mode
