"that are greater than" should have been "that are greater than or equal to"



Dave Peterson wrote:

Maybe you could use format|conditional formatting to highlight those cells?

Select your range
(I used A1:A20)
and with A1 the activecell
format|conditional formatting
formula is
=A1=LARGE(A:A,3)

This will highlight all the values that are greater than the 3rd highest value
(watch what happens with ties).

Mistysweep wrote:

Hi,

I have a colum of data aist and would like to be able to highlight the three
highest values in the column, but don't want to sort the data.
--
Many thanks

Mistysweep

--

Dave Peterson

--

Dave Peterson