software

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

quot;QPapillonquot; wrote:

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

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 :-)
------------------------------*------------------------------*----------------quot;QPapillonquot; gt; wrote in message
...
gt; Hi - I'm trying to use conditional format to highlight the highest number
gt; in
gt; a row of numbers derived from a formula. I tried MAX (a1:h1) but it
gt; highlighted all the numbers.
gt;
gt; What am I doing wrong?
gt;
gt;
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?

quot;Ken Wrightquot; wrote:

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

Try this:

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

This will highlight only the first instance of MAX.

Biff

quot;ellebellequot; gt; wrote in message
...
gt; if there are two cells containing the same value this formula highlights
gt; the
gt; second. Is there a formula to highlight the first instance of the highest
gt; value?
gt;
gt; quot;Ken Wrightquot; wrote:
gt;
gt;gt; Select A1:H1 and use =A1=MAX($A$1:$H$1) then set your formats
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt; Ken....................... Microsoft MVP - Excel
gt;gt; Sys Spec - Win XP Pro / XL 97/00/02/03
gt;gt;
gt;gt; ------------------------------*------------------------------*----------------
gt;gt; It's easier to beg forgiveness than ask permission :-)
gt;gt; ------------------------------*------------------------------*----------------
gt;gt;
gt;gt;
gt;gt; quot;QPapillonquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi - I'm trying to use conditional format to highlight the highest
gt;gt; gt; number
gt;gt; gt; in
gt;gt; gt; a row of numbers derived from a formula. I tried MAX (a1:h1) but it
gt;gt; gt; highlighted all the numbers.
gt;gt; gt;
gt;gt; gt; What am I doing wrong?
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;