+ Reply to Thread
Results 1 to 7 of 7

Highlight the top 10 sales

  1. 04-16-2015, 04:54 AM #1
    Nisha Dhawan
    Nisha Dhawan is offline
    Valued Forum Contributor
    Join Date
    05-07-2014
    Location
    India
    MS-Off Ver
    MS Office 365
    Posts
    313

    Highlight the top 10 sales

    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
    Thanks
    Nisha Dhawan


    If you like my answer please click on * Add Reputation
    "If you can dream it, You can do it "
    Reply With QuoteRegister To Reply
  2. 04-16-2015, 05:04 AM #2
    adhawan06
    adhawan06 is offline
    Valued Forum Contributor
    Join Date
    04-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, 2019, Office 365, Google Spreadhsheet
    Posts
    640

    Re: Highlight the top 10 sales

    Hi Nisha,

    Simply Select your entire range, then Go To Conditional Formatting-->Top/Bottom Rules-->Top 10 Items (You can set the numbers as per your choice)-->Okay
    Thanks,
    Anil Dhawan


    Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.

    Don't stop when you are tired. STOP when you are done!
    Reply With QuoteRegister To Reply
  3. 04-16-2015, 05:06 AM #3
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: Highlight the top 10 sales

    HI,

    keybord shortcut Alt + H + L + T + T
    select the column and use the shortcut, you can find the same in Conditional format tab in Home tab .

    shorttcut for highlight the top 10

    Punnam
    Reply With QuoteRegister To Reply
  4. 04-16-2015, 05:09 AM #4
    ashishmehra2010
    ashishmehra2010 is offline
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: Highlight the top 10 sales

    Hi Nisha,

    Please check the attached file. If I have helped you then please mark this as Solved.

    You can use
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    in CF.

    Regards,
    AM
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 04-16-2015, 05:38 AM #5
    Nisha Dhawan
    Nisha Dhawan is offline
    Valued Forum Contributor
    Join Date
    05-07-2014
    Location
    India
    MS-Off Ver
    MS Office 365
    Posts
    313

    Re: Highlight the top 10 sales

    Thanks to all, it worked.
    Reply With QuoteRegister To Reply
  6. 04-16-2015, 05:40 AM #6
    adhawan06
    adhawan06 is offline
    Valued Forum Contributor
    Join Date
    04-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, 2019, Office 365, Google Spreadhsheet
    Posts
    640

    Re: Highlight the top 10 sales

    Glad It helped and thanks for adding reputation Nisha.
    Reply With QuoteRegister To Reply
  7. 04-16-2015, 05:45 AM #7
    ashishmehra2010
    ashishmehra2010 is offline
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: Highlight the top 10 sales

    Thanks Nisha for adding rep
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Highlight the top 10 sales
    By Nisha Dhawan in forum Excel General
    Replies: 4
    Last Post: 04-16-2015, 05:43 AM
  2. Each Item Sales contribution in Total Sales percentage wise and Chart or Graph
    By rubusmubu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2013, 12:52 PM
  3. Sales Goals - using rolling 12 month sales and minimum monthly sales
    By kmlloyd in forum Excel General
    Replies: 6
    Last Post: 10-19-2013, 04:53 PM
  4. Extract Monthly Data from a Sales Database (Sumup Sales Value Occurred in Same Date)
    By maniknandi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-23-2013, 07:56 AM
  5. Transform an Excel sales table with multiple monthly sales column into an Access DB
    By Feyroce in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2012, 10:19 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1