On 5/14/08 6:36 PM, in article
hnwaxman-B48E06.18363614052008@[EMAIL PROTECTED]
"Harvey Waxman"
<hnwaxman@[EMAIL PROTECTED]
> wrote:
> 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)
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
|
