Highlight the top 10 sales

[Nisha Dhawan]

Hello Everyone,

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".

Thanks
Nisha

[NeedForExcel]

Select Data > Go to Conditional Formatting > Top/Bottom Rules > Top 10 Items ..

[adhawan06]

Cross Post --> http://www.excelforum.com/excel-gene...-10-sales.html

[Nisha Dhawan]

Thanks it worked

[NeedForExcel]

Glad!

Please mark the thread as solved if you have your answer..