Highlight MAX Cell Greater Than Zero

[Nate]

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(B9>0,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

 

[Mike H]

Try this CF formula

=AND(B9=MAX(B9:$G$9),B9>0)

Mike

 

[Sheeloo]

Select B9:G9 and use the formula
=B9=MAX($B$9:$G$9)

 

[Nate]

Thanks Mike! That worked perfectly!

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

 

[Nate]

That doesn't work. It highlights every cell if they are all equal to 0.