conditional formatting - Highest

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" <QPapillon@discussions.microsoft.com> wrote in message
news:916DB738-D199-4080-87EC-9B86732ED607@microsoft.com...
> 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?
>
>