top of page

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

Profit and Loss Forecast
Profit and Loss Forecast

This template simplifies the creation and analysis of your company's income statement. It guides users through a systematic process of inputting financial data and...

Excel Resume
Excel Resume

This template will help you take control of your career by presenting yourself in a PROFESSIONAL manner…all directly from Excel.
Simply hit CTRL + P and you’ll get a PDF that’s perfect for you to use on your next interview.

8 Popular Accounting Tasks You can do in Excel
8 Popular Accounting Tasks You can do in Excel

This template showcases 8 data transformation and manipulation tasks achievable using Power Query, enhancing data...

Cover Dashboard
Cover Dashboard

This is a Dashboard that can be used as a cover for your financial model.

bottom of page