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...![]()
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...![]()
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks