Category Archives: Intermediate Excel Tutorials

Conditional Formatting IF Statements

Conditional Formatting Using Formulas in Excel

A tutorial on using Conditional Formatting Formulas in Excel.

Excel Conditional Formatting using IF statements
Excel Conditional Formatting using IF statements

There are significant limitations with the preconfigured options for Conditional Formatting. They typically only apply so a single cell without consideration for multiple factors. For example, in a previous tutorial I showed how to highlight a cell for an overdue payment based upon the date that it was due and the date that you specify for comparison. That formatting remains even after the payment has been made.

In order to correct that problem we need to use statements to examine the contents of other cells.

Continue reading Conditional Formatting IF Statements