Conditional Formatting with Formulas

Access our COMPLETE Excel Course HERE

In this video we demonstrate how to incorporate formulas into your conditional formatting logic.

We break the process down into simple steps to help you understand how the logic works and how to implement yourself. Don't forget you can download the exact workbook used in this tutorial at the link below.

Conditional Formatting is a great addition to any workbook or summary to quickly help the user identify when certain criteria has been met. In our example we use conditional formatting to identify when movie rentals pass an agreed return date and become OVERDUE.

Download tutorial workbook HERE