Joe,

Select all rows 3 to 28 (or cells that you actually want shaded, so that
cell A3 is the activecell), and use Format / CF... with a "Formula is" of

=AND(MAX($D$3:$D$28)45,$I3=MAX($I$3:$I$28))

Set your format for a fill of blue, and you're done. Of course, if there
are two or more values that match then highest value in column A, they will
all be colored.

HTH,
Bernie
MS Excel MVP



"Joe" wrote in message
...
I'm trying to setup conditional formatting in Excel and not having much
luck.

My criteria is where any cell from d3:d28 is greater than 45, than tell me
the highest value from i3:28 and color the winning cell in "i" blue.

If possible, instead of coloring the winning cell in "i" blue, I'd like to
color the entire row it resides in.

Thanks