| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| highlight from top to bottom of spreadsheet without scrolling? | Excel Worksheet Functions | |||
| summation to show at the bottom when I highlight selected cells? | Excel Worksheet Functions | |||
| column of dollar amounts don | New Users to Excel | |||
| When i highlight cells, I USED to get total in bottom rt corner? | Excel Worksheet Functions | |||
| dislike jump bottom of column by double-clicking the bottom of cel | Excel Discussion (Misc queries) | |||
Linear Mode
