In article <C4519927.ABFF8%bob@[EMAIL PROTECTED]
>,
Bob Greenblatt <bob@[EMAIL PROTECTED]
> wrote:
> 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)
That explains it. Thanks
|
