'CF-min-max' category

You are here: Excel » Conditional formatting » CF-min-max »

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

Excel categories

FunctionsFormulasExcel TablesAdvanced FilterData ValidationDrop DownNamed RangesExcel SolverChartsConditonal FormattingPivot TablesVBAMacrosUDFsArchive