Conditional formatting Max and Min

[Guest]

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.

 

[vezerid]

Say your data are in A1:A10. Select A1:A10, Format>Conditional
Formatting...> Formula Is:

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

Similarly for MIN.

HTH
Kostis Vezerides

 

[Bob Phillips]

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)

 

[Guest]

try:

FormulaIs: =A1=MAX(A:A)

FormulaIs: =A1=MIN(A:A)