Conditional Formatting

This template applies formatting rules based on specified conditions, visually highlighting or emphasizing data that meets certain criteria.

Instructions

In this workbook we have a number of tabs to teach you different types of conditional formatting.

In each tab you will find:

Instructions
A problem to solve
A solution to that problem

More Templates

Sales Dashboard

This dashboard shows you total sales compared to last year, average monthly sales to set realistic targets, quarterly breakdowns to reveal seasonal patterns...

Financial Health Dashboard

This dashboard showcases your financial and cash metrics, indicating how good your business is doing

Cash Flows Dashboard

The Cash Flows Dashboard tracks your company’s cash inflows and outflows, offering insights into liquidity and cash management...

Excel Proposal

This template is a structured spreadsheet designed to outline project details, objectives, timelines, costs, and deliverables...