identify highest and lowest number in a list

[peter terry]

hi


I need to be able to look through a list of numbers and identify the highest
and lowest number in the list.

The list can vary in length up to 60 or so entries, and not all of the cells
will have data in them.

I know there's a conditional format in there somewhere but that's about it!

 

[RagDyer]

Have you tried the MAX() and MIN() functions?
Look them up in Help.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

hi


I need to be able to look through a list of numbers and identify the highest
and lowest number in the list.

The list can vary in length up to 60 or so entries, and not all of the cells
will have data in them.

I know there's a conditional format in there somewhere but that's about it!

 

[Guest]

try using auto filter.

 

[Debra Dalgleish]

Select the cells (A2:A60 in this example, with A2 as the active cell)
Choose Format>Conditional Formatting
From the first dropdown, choose Cell Value Is
In the next dropdown, choose 'equal to'
In the text box, type: =MAX(A$2:A$60)
Click the Format button, and on the Patterns tab, select a colour
Click OK

Click the Add button
For condition 2, from the first dropdown, choose Formula Is
In the text box, type: =A2=MIN(IF(A$2:A$60<>"",A$2:A$60))
Click the Format button, and on the Patterns tab, select a colour
Click OK, click OK

 

[peter terry]

That's cracked it! thank you very much

Select the cells (A2:A60 in this example, with A2 as the active cell)
Choose Format>Conditional Formatting
From the first dropdown, choose Cell Value Is
In the next dropdown, choose 'equal to'
In the text box, type: =MAX(A$2:A$60)
Click the Format button, and on the Patterns tab, select a colour
Click OK

Click the Add button
For condition 2, from the first dropdown, choose Formula Is
In the text box, type: =A2=MIN(IF(A$2:A$60<>"",A$2:A$60))
Click the Format button, and on the Patterns tab, select a colour
Click OK, click OK