| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple minimums, quick ?
I received help and formula for conditional formatting similar to
=C7<small(c7:h7,4) etc. but it highlights the empty cells too. I want it to highlght the 4 smallest numbers but I will have some blanks in range so how do I get it to ignore the blanks and not highlight them??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiple minimums, quick ?
=AND(C7<"",C7<small(c7:h7,4))
-- Gary''s Student - gsnu200903 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding multiple minimums??? | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
