| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format based upon if statement and max
What I'm attempting to do is write a formula within a conditional format that
uses an if statement and then performs a max lookup within a column. For example: =if a5="eligible", =max(f5:f33) and then highlight the applicable max cell in column f . Any help would be greatly appreciated. This forum is a great resource! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change different cell based on conditional statement | Excel Worksheet Functions | |||
| Conditional format based off of a logical if statement | Excel Discussion (Misc queries) | |||
| IF Statement based on Conditional format | Excel Discussion (Misc queries) | |||
| If statement based on currency format | Excel Worksheet Functions | |||
| Conditional formatting based on if statement. | Excel Worksheet Functions | |||
Threaded Mode
