highlighting

D

dexter

how do i highlight the highs and lows of a set of
numbers? any help would be great. thanks in advance.
 
S

Steven M (remove cola to reply)

how do i highlight the highs and lows of a set of
numbers? any help would be great. thanks in advance.
Click to expand...

I have done that.

Use Conditional formatting, with formulas like
=max(set) and
=min(set).
 
B

Bob Phillips

Use Conditional Formatting (Format>Conditional Formatting) and use
Conditions of Formula Is with a formula of

=A1=MIN($A$1:$A$100)

and

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

then format to suit.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top