Highlight MAX Cell Greater Than Zero

N

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
 
N

Nate

Thanks Mike! That worked perfectly!

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top