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!