# Highlight Min value in range greater than

#### cvincent

##### Board Regular
I have a column of percentages, and need to highlight the smallest value that is greater than 80%. This report is updated daily. I would like to know how to set conditional formatting to do this, or at least have a formula or run a macro to do this.

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
You could use this array-entered** formula to get that value (just change the range as needed and format the cell the formula is in as a percentage)...

=MIN(IF(B1:B100>80%,B1:B100))

** Commit this formula using CTRL+SHIFT+ENTER and not just Enter by itself

Or use this for your conditional format (data in H1:H20) =SMALL(\$H\$1:\$H\$10,COUNT(\$H\$1:\$H\$10)-(COUNTIF(\$H\$1:\$H\$10,">.8")-1))=H1

This worked Rick - thank you so much. Have a good day.

You could use this array-entered** formula to get that value (just change the range as needed and format the cell the formula is in as a percentage)...

=MIN(IF(B1:B100>80%,B1:B100))

** Commit this formula using CTRL+SHIFT+ENTER and not just Enter by itself

Thank you for your response Ben. I've added Rick's formula to my spreadsheet and it works great.

Replies
3
Views
100
Replies
5
Views
122
Replies
3
Views
700
Replies
6
Views
206
Replies
3
Views
118

1,203,759
Messages
6,057,191
Members
444,913
Latest member
ILGSE

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back