conditional format

[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

 

[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

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)

 

[Harvey Waxman]

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)

That explains it. Thanks