Try this:

Select the range of cells F5:F33
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=AND($A$5="eligible",F5=MAX(F$5:F$33))
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"CARFL97" wrote in message
...
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!