Conditional Formatting
 

I want the highest number in the below range of numbers to highlight in a
different color no matter how many times it changes. How can I do that?

$3,485.00
$475.00
$100.00
$1,190.00
$4,245.00
$- 0
$3,277.00
$10,035.00
$- 0
$2,930.00
$- 0

Conditional Formatting
 

Try "Conditional Formatting".

Say your datalist was in A1 to A11.
Select the *entire* list, with the focus on A1 (colored white), then:

<Format <Conditional Format,
Change "Cell Value Is" to "Formula Is",
And enter this formula:

=AND(A1=MAX($A$1:$A$11),A1<"")

Then click on <Format, and choose a font and/or pattern color to your
liking.
Then <OK <OK

Duplicate max values will *all* be highlighted.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"kimmy2003" wrote in message
...
I want the highest number in the below range of numbers to highlight in a
different color no matter how many times it changes. How can I do that?

$3,485.00
$475.00
$100.00
$1,190.00
$4,245.00
$- 0
$3,277.00
$10,035.00
$- 0
$2,930.00
$- 0

Conditional Formatting
 

CF/ Cell value is/ Equal to/ =MAX(A$1:A$11)
Select your highlighting format.
--
David Biddulph

"kimmy2003" wrote in message
...
I want the highest number in the below range of numbers to highlight in a
different color no matter how many times it changes. How can I do that?

$3,485.00
$475.00
$100.00
$1,190.00
$4,245.00
$- 0
$3,277.00
$10,035.00
$- 0
$2,930.00
$- 0