Highlight Min value in range greater than

[cvincent]

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.

 

[Rick Rothstein]

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

 

[BenMiller]

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

 

[cvincent]

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

 

[cvincent]

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