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.

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

On Jun 21, 7:14 pm, Sean E <Sean E...@discussions.microsoft.com>
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.

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 (E-Mail Removed)> wrote in message
news:49ACFF28-57A5-4D99-9D16-(E-Mail Removed)...
> 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.

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.