A tutorial on using Conditional Formatting Formulas in Excel.
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.