highlight the max,min and average in a row

  • Thread starter Thread starter hilary
  • Start date Start date
H

hilary

does anyone know how to highlight the MAX,MIN and MID value in
column?????

i have sales in a column showing them day by day and i want t
highlight the max,min and mid values in different colour
automaticly.

is there anyway to do that without finding the max or min and put it i
a different cell. i mean i want to highlight them in the place they ar
in.

also how you find the mid one i know about average but i need one o
those actual number as medium.

help pleaseee
 
Hi
try the following in your case:
- select the columns (e.g. A1:A100)
- goto 'Format - Conditional Format'
- enter the following formula
=A1=MAX($A$1:$A$100)
- choose a format
- add a condition and enter the formula
=A1=MIN($A$1:$A$100)
- add another condition and enter
=A1=MEDIAN($A$1:$A$100)
(note this highlights the median and not the average value)
 
You can use conditional formatting, to get max select the range
(assume you select from A1:A200), with A1 as the active cell do
format>conditional formatting, select formula is and use

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

click the format button and select either a different font colour or a
different pattern,

select add and add a second condition but replace MAX with MIN, select a
colour, and finally add a third
and replace MIN with AVERAGE, select a colour and click OK twice

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top