+ Reply to Thread
Results 1 to 2 of 2

round up conditional formatting bottom 10%

  1. #1
    Registered User
    Join Date
    01-13-2016
    Location
    Leuven, Belgium
    MS-Off Ver
    2010
    Posts
    1

    round up conditional formatting bottom 10%

    I have a list of 125 values. In this list I would like to highlight the bottom 10%. If I use conditional formatting, it shows 12 values. How can I 'round up' the nummber of highlights to 13?

    I really have no idea how I can manage this...

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: round up conditional formatting bottom 10%

    When you choose the bottom 10%, that is the bottom 10% of the values and the number of values formatted will change with the number of values present.

    Instead of using Bottom 10% try using Bottom 10 items. You can change the number in the dialogue to what you want when .

    If you are actually wanting the bottom 13%, you can change that in the dialogue box after clicking on the bottom 10%.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting Top/Bottom 10% rule
    By User3 in forum Excel General
    Replies: 7
    Last Post: 05-11-2015, 03:59 AM
  2. Macro for conditional formatting bottom border
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-17-2014, 10:11 AM
  3. conditional formatting bottom border
    By graiggoriz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-26-2014, 10:20 AM
  4. Top/Bottom Rule for Conditional formatting
    By thequebs in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-28-2014, 05:31 PM
  5. Top Bottom Conditional Formatting
    By Grimc054 in forum Excel - New Users/Basics
    Replies: 19
    Last Post: 10-28-2013, 03:50 AM
  6. Formula for Conditional Formatting Bottom 5 excluding 0's
    By FlyinIron406 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-10-2013, 02:23 AM
  7. [SOLVED] Conditional formatting between top 30% & bottom 30%
    By SChapman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-28-2013, 03:06 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1