D dexter Jun 2, 2004 #1 how do i highlight the highs and lows of a set of numbers? any help would be great. thanks in advance.
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) Jun 2, 2004 #2 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).
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 Jun 2, 2004 #3 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)
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)
