Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding multiple minimums???
If I have a section of cells with numbers and want the 4 smallest numbers to
be highlighted what should I do? It would make life much easier if excel could just highlight those 4 smallest values for me after all the data is input into the range that has that formatting. Thanks for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding multiple minimums???
Suppose those numbers are in A1:A20. Select that range, with A1 as the
active cell, then bing up the Conditional Formatting dialogue box and choose Formula Is rather than Cell Value Is in the first box and enter this formula: =A1<SMALL(A$1:A$20,5) Click on the Format button, then on the Patterns tab, and choose your colour. Click OK twice, and then the 4 lowest values will be highlighted with the colour you chose. Hope this helps. Pete On Sep 14, 10:01*pm, Texas10 wrote: If I have a section of cells with numbers and want the 4 smallest numbers to be highlighted what should I do? *It would make life much easier if excel could just highlight those 4 smallest values for me after all the data is input into the range that has that formatting. *Thanks for any help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding multiple minimums???
Let's assume your "section of cells" is C7:H20... select them (I'll be
assuming C7 is the active cell... the active cell won't be shaded)... click Format/Conditional Formatting... select "Formula Is" from the first drop down and then put this in the empty field next to it... =C7<=SMALL($C$7:$H$20,4) Note the first use of C7 (also note the relative address) is because it is the active cell. The second C7 (note the absolute address on it and the end cell in the range)... that is the address range of your "section of cells". Next, click the Format button, select the Patterns tab and select a relatively light tinted color (so your value will show up against it) and finally, OK your way back to the worksheet. Your lowest 4 values should now have their cells shaded in the color you selected. -- Rick (MVP - Excel) "Texas10" wrote in message ... If I have a section of cells with numbers and want the 4 smallest numbers to be highlighted what should I do? It would make life much easier if excel could just highlight those 4 smallest values for me after all the data is input into the range that has that formatting. Thanks for any help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding multiple minimums???
Thank you both for the help |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding multiple minimums???
Well some of the cells are blank and the formatting highlights the blank
cells as well, so how can I make an adjustment to the formula to have it ignore blank cells and only highlight the 4 smallest numbers? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding multiple minimums???
Okay, in that case use this formula instead...
=AND(C7<=SMALL($C$7:$H$20,4),C7<"") -- Rick (MVP - Excel) "Texas10" wrote in message ... Well some of the cells are blank and the formatting highlights the blank cells as well, so how can I make an adjustment to the formula to have it ignore blank cells and only highlight the 4 smallest numbers? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding multiple code dates for multiple item number | Excel Worksheet Functions | |||
dialog box for axis minimums, maximums, and major units | Charts and Charting in Excel | |||
How do I set log chart minimums and maximum? | Charts and Charting in Excel | |||
setting maximums or minimums | Excel Discussion (Misc queries) | |||
Multiple minimums for the same column | Excel Worksheet Functions |