How to highlight Top 10 and Bottom 10 Amounts in a Column
 

Hello-

Can anyone help me find out How to highlight the Top 10 and Bottom 10
Amounts in a Column? Ideally I would like one color for the top 10 and a
different color for the bottom 10.

Thank you very much!!

Filo

How to highlight Top 10 and Bottom 10 Amounts in a Column
 

You can do it with conditional formatting. The formula in the CF for Cell A1
will look like this...

=A1=LARGE(A:A, 10)
The second criteria would be
=A1<=small(A:A, 10)
--
HTH...

Jim Thomlinson


"Filo" wrote:

Hello-

Can anyone help me find out How to highlight the Top 10 and Bottom 10
Amounts in a Column? Ideally I would like one color for the top 10 and a
different color for the bottom 10.

Thank you very much!!

Filo