Conditional Formatting

K

kimmy2003

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
 
R

RagDyeR

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!
=====================================================

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
 
D

David Biddulph

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