So if the max occurred in the 60 or 90 day column, then nothing would be
highlighted?

If yes...

With the data in A1:E7 (headers in row 1)
I selected E2:E7
and then Format|conditional formatting
formula is:
=e2=max($c2:$e2)

In your test data, wouldn't all those sites get the highlight?


JH wrote:

I am using excel 2003 and would like to use conditional formatting to
highlite the 120 day column with the highest % for each site regardless of
month. For example for Phil it would be 98.16, for Mech it would be 96.42.
Any help would be much appreciated. Thanks.

site Mon/Yr 60 day 90 day` 120 day
Phil Jan-06 89.61 95.54 96.75
Mech Jan-06 85.44 93.54 95.02
Nua Jan-06 88.44 93.58 95.6
Phil Feb-06 92.77 96.37 98.16
Mech Feb-06 87.81 95.6 96.43
Nua Feb-06 88.89 93.71 96.04

--

Dave Peterson