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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 How to improve network speed in Windows 10 by increasing IRPStackSize 5
Multiple SUM's in a column 15
Find top 10 items in a range 7
top 10 subtotaling 2
Windows 10 operating system - using firefox browser - yahoo mail. 5
top 10 analysis 1
macro to set bottom and top values for randbetween 6
Finding the top 10 from a month of data 1

Back
Top