multiple minimums, quick ?

T

Texas10

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top