identify highest and lowest number in a list

  • Thread starter Thread starter peter terry
  • Start date Start date
P

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!
 
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!
 
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
 
That's cracked it! thank you very much


Debra Dalgleish said:
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
Click to expand...
 
Back
Top