Excel » Conditional formatting » CF-min-max »

Highlight closest number

This post decribes how to highlight records with closest value to a criterion. You can also choose to highlight the […]

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 […]