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.

Need some clarification.

So, if D25 = 50 and I5 is "the highest value from i3:28" color cell I5 or
"the entire row it resides in."

Is the entire row A5:IV5?

Biff

"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