Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Bottom 10 with "ties"
Hello all -
I am wanting to highlight the Bottom 10 cells in a range ($D$6:$D$25), I've got the basic formula but am confused when it comes to cells with "ties" (a.k.a. the same number), as it wants to highlight more than 10 cells at times. My formula is: =D6<=SMALL($D$6:$D$25,10) How can I modify this so it will account for a "tie" with another cell? Thanks! Dan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Bottom 10 with "ties"
See reply in .Functions
Biff "dan" wrote in message ups.com... Hello all - I am wanting to highlight the Bottom 10 cells in a range ($D$6:$D$25), I've got the basic formula but am confused when it comes to cells with "ties" (a.k.a. the same number), as it wants to highlight more than 10 cells at times. My formula is: =D6<=SMALL($D$6:$D$25,10) How can I modify this so it will account for a "tie" with another cell? Thanks! Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Bottom 10 with "ties" | Excel Worksheet Functions | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
Conditional Formatting Not Working Consistently | Excel Discussion (Misc queries) |