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
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