Highlight MAX Cell Greater Than Zero
 

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

Highlight MAX Cell Greater Than Zero
 

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

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

Highlight MAX Cell Greater Than Zero
 

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

Highlight MAX Cell Greater Than Zero
 

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

"Sheeloo" wrote:

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