How to check the conditional formats in your Excel file

Conditional formatting is extremely useful. You'll find it in several places in the Handbook models.

It's easy to lose track of all the conditional formats in your model. Excessive conditional formatting can cause file size bloat, and so we want to be able to check and remove conditional formatting easily.

This guide will show you how to create a list of all the conditional formats used in your Excel file, and then easily choose the ones you want to remove.

This post is for subscribers only

Already have an account? Sign in.


Sign in or become a Financial Modelling Handbook member to join the conversation.
Just enter your email below to get a log in link.

Subscribe to Financial Modelling Handbook

Don’t miss out on the latest financial modelling guides. Sign up now to get access to the library of members-only guides.