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?

conditional formatting - Highest
 

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?

conditional formatting - Highest
 

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" wrote in message
...
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?

conditional formatting - Highest
 

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" wrote in message
...
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?

conditional formatting - Highest
 

Try this:

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

This will highlight only the first instance of MAX.

Biff

"ellebelle" wrote in message
...
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" wrote in message
...
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?