Hi - I'm trying to use conditional format to highlight the highest number in
a row of numbers derived from a formula. I tried MAX (a1:h1) but it
highlighted all the numbers.

What am I doing wrong?

Try this instead:

=A1=MAX($A$1:$H$1)

HTH,
Elkar

"QPapillon" wrote:

> Hi - I'm trying to use conditional format to highlight the highest number in
> a row of numbers derived from a formula. I tried MAX (a1:h1) but it
> highlighted all the numbers.
>
> What am I doing wrong?
>
>

Select A1:H1 and use =A1=MAX($A$1:$H$1) then set your formats

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"QPapillon" <(E-Mail Removed)> wrote in message
news:916DB738-D199-4080-87EC-(E-Mail Removed)...
> Hi - I'm trying to use conditional format to highlight the highest number
> in
> a row of numbers derived from a formula. I tried MAX (a1:h1) but it
> highlighted all the numbers.
>
> What am I doing wrong?
>
>

if there are two cells containing the same value this formula highlights the
second. Is there a formula to highlight the first instance of the highest
value?

"Ken Wright" wrote:

> Select A1:H1 and use =A1=MAX($A$1:$H$1) then set your formats
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ------------------------------Â*------------------------------Â*----------------
> It's easier to beg forgiveness than ask permission :-)
> ------------------------------Â*------------------------------Â*----------------
>
>
> "QPapillon" <(E-Mail Removed)> wrote in message
> news:916DB738-D199-4080-87EC-(E-Mail Removed)...
> > Hi - I'm trying to use conditional format to highlight the highest number
> > in
> > a row of numbers derived from a formula. I tried MAX (a1:h1) but it
> > highlighted all the numbers.
> >
> > What am I doing wrong?
> >
> >
>
>
>

Try this:

=AND(A1=MAX($A1:$H1),COUNTIF($A1:A1,A1)=1)

This will highlight only the first instance of MAX.

Biff

"ellebelle" <(E-Mail Removed)> wrote in message
news:5B888094-EDD0-411F-89F0-(E-Mail Removed)...
> if there are two cells containing the same value this formula highlights
> the
> second. Is there a formula to highlight the first instance of the highest
> value?
>
> "Ken Wright" wrote:
>
>> Select A1:H1 and use =A1=MAX($A$1:$H$1) then set your formats
>>
>> --
>> Regards
>> Ken....................... Microsoft MVP - Excel
>> Sys Spec - Win XP Pro / XL 97/00/02/03
>>
>> ------------------------------*------------------------------*----------------
>> It's easier to beg forgiveness than ask permission :-)
>> ------------------------------*------------------------------*----------------
>>
>>
>> "QPapillon" <(E-Mail Removed)> wrote in message
>> news:916DB738-D199-4080-87EC-(E-Mail Removed)...
>> > Hi - I'm trying to use conditional format to highlight the highest
>> > number
>> > in
>> > a row of numbers derived from a formula. I tried MAX (a1:h1) but it
>> > highlighted all the numbers.
>> >
>> > What am I doing wrong?
>> >
>> >
>>
>>
>>