Conditional formatting Max and Min
 

Using Microsoft Excel 2000, I'm attempting to make the max value and min
value of a set of unique numbers turn a certain color. I've tried numerous
different ways using cell value and formula but am unable to have just those
two values turn to a different color. Usually I'll have several if not all of
the numbers change color.

Any ideas? Thanks.

Conditional formatting Max and Min
 

Say your data are in A1:A10. Select A1:A10, FormatConditional
Formatting... Formula Is:

=A1=MAX($A$1:$A$10)

Similarly for MIN.

HTH
Kostis Vezerides

On Jun 21, 7:14 pm, Sean E <Sean
wrote:
Using Microsoft Excel 2000, I'm attempting to make the max value and min
value of a set of unique numbers turn a certain color. I've tried numerous
different ways using cell value and formula but am unable to have just those
two values turn to a different color. Usually I'll have several if not all of
the numbers change color.

Any ideas? Thanks.

Conditional formatting Max and Min
 

http://www.xldynamic.com/source/xld.CF.html#top3

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Sean E" <Sean wrote in message
...
Using Microsoft Excel 2000, I'm attempting to make the max value and min
value of a set of unique numbers turn a certain color. I've tried numerous
different ways using cell value and formula but am unable to have just
those
two values turn to a different color. Usually I'll have several if not all
of
the numbers change color.

Any ideas? Thanks.

Conditional formatting Max and Min
 

try:

FormulaIs: =A1=MAX(A:A)

FormulaIs: =A1=MIN(A:A)


"Sean E" wrote:

Using Microsoft Excel 2000, I'm attempting to make the max value and min
value of a set of unique numbers turn a certain color. I've tried numerous
different ways using cell value and formula but am unable to have just those
two values turn to a different color. Usually I'll have several if not all of
the numbers change color.

Any ideas? Thanks.