C
CARFL97
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!
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!