ExcelBanter - multiple minimums, quick ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - multiple minimums, quick ? (https://www.excelbanter.com/excel-discussion-misc-queries/242683-multiple-minimums-quick.html)

Texas10

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???

Gary''s Student

multiple minimums, quick ?

=AND(C7<"",C7<small(c7:h7,4))
--
Gary''s Student - gsnu200903

All times are GMT +1. The time now is 11:22 AM.