Thanks Mike! That worked perfectly!

Sorry for the delay in my response - I've been having trouble logging into
this website recently.

"Mike H" wrote:

Try this CF formula

=AND(B9=MAX(B9:$G$9),B90)

Mike

"Nate" wrote:

I'm trying to use a conditional format to highlight the Maximum value in a
row of cells, as long as at least 1 of the cells in the row is greater than
zero. So far I've been unsuccessful.
The formula I was trying is =IF(B90,MAX($B$9:$G$9),""). That highlights
all cells greater than zero. If I just use =MAX($B$9:$G$9) and the row is
all 0's than it will highlight every cell.

XL2003