Highlight lookup values

I would like to show you how to search a table using conditional formatting. The criteria highlight matching column and […]

Quickly highlight records containing text strings in excel (AND Logic)

This blog post shows you how to highlight rows where text string criteria are found. Example, continents criterion (cell B3) […]

Highlight records [AND logic]

This blog post shows you how to create a conditional formatting formula and highlight matching records. You can easily change […]

Highlight records – multiple criteria [OR logic]

This blog post shows you how to highlight rows with multiple criteria using OR logic. The criteria is found in […]