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

Similar Threads

Finding multiple minimums??? 5
data from multiple files: best way to extract 1
Shifting rows down in a table 2
Paragraph numbering in Word 1
Conditional Formatting? 3
VLOOKUP and IF Statements 2
Check if Duplicate with Exceptions 6
error in highlighting duplicate values in excel 1

Top