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.
|