conditional format

H

Harvey Waxman

row containing several numerical values

I'd like to conditionally format the row such that the maximum value is
automatically formatted.

"formula is" "=max(1B:1P)"

then choose a format.

It doesn't work. All the values in the row show the same format, not
the maximum value alone.

Can I do this without an auxiliary cell containing the maximum value?

Thanks

Excel X in Leopard
 
B

Bob Greenblatt

row containing several numerical values

I'd like to conditionally format the row such that the maximum value is
automatically formatted.

"formula is" "=max(1B:1P)"

then choose a format.

It doesn't work. All the values in the row show the same format, not
the maximum value alone.

Can I do this without an auxiliary cell containing the maximum value?

Thanks

Excel X in Leopard
Click to expand...
Yes you can. In the formula stated above, the answer will always be TRUE
unless the entire range contained zeros, blanks or nulls. Did you select the
entire row before entering the formula? Remember that the formula must
return a TRUE or FALSE value, yours is always TRUE. With the entire row
selected, and A1 the active cell, the formula should be:
=a1=max($B$1:$P$1)
 
H

Harvey Waxman

Bob Greenblatt said:
Yes you can. In the formula stated above, the answer will always be TRUE
unless the entire range contained zeros, blanks or nulls. Did you select the
entire row before entering the formula? Remember that the formula must
return a TRUE or FALSE value, yours is always TRUE. With the entire row
selected, and A1 the active cell, the formula should be:
=a1=max($B$1:$P$1)
Click to expand...

That explains it. Thanks
 
Top