Highlight closest number
This post demonstrates how to highlight records with the closest value to a criterion, you can also choose to highlight […]

How to highlight MAX and MIN value based on month
The image above shows rows highlighted based on value in column C being the largest or smallest in that particular […]

Highlight smallest duplicate number
Question: How do I highlight the smallest duplicate value in a column using conditional formatting? Answer: Conditional formatting formula in […]