Highlight the Top 10 Sales through Conditional Formatting

Question asked by user @ Excel forum:-

How to highlight the top 10 sales through Conditional Formatting?

I have a list of sales in which I have sales amount. I want to highlight the top sales on the basis of sales amount, how I can do it through "Conditional Formatting".

image 1


Follow below given steps to highlight the top 10 sales:-

  • Select the range A2:B21 & press ALT + O + D shortcut key to open Conditional Formatting Rules Manager.

image 2


  • Click on New Rule; New Formatting Rule window will appear

image 3


  • Select “Use a formula to determine which cells to format”
  • In “Format values where this formula is true” enter the following formula
  • =$B2>=LARGE($B$2:$B$21,10)

image 4


  • Click on Format & pick the color of your choice.
  • Click on Ok button twice you will see Conditional Formatting gets applied on the selected range of cells refer below snapshot

image 5

In this way we can highlight top 10 or any value from large amount of data using conditional formatting feature of excel.


Main Page


Conditional Format Based on Dates

Find Occurrence of Text in a Column

How to Highlight a row on the basis of Cell

Compare 2 Columns and Return Fill Red if is different

How to check the row and then highlight the first cell of the row

Highlight Cells Tomorrow Excluding Weekend

Conditional Formatting to Mark Dates on a Calendar

How to apply Conditional Formatting  in a Cell before a Particular Character

Highlight the Top 10 Sales through Conditional Formatting

Conditional Formatting for Pivot Tables

Conditional Format Between First and Last Non-Blank Cells




Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube