Highlight MAX Cell Greater Than Zero
Select B9:G9 and use the formula
=B9=MAX($B$9:$G$9)
"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
|