Tag Archives: Conditional Formatting

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

Conditional Formatting Based on a Date

Conditional Formatting Dates in Excel

A tutorial on applying conditional formatting to Excel based upon a date in the past, future or present.

Applying conditional formatting on a date within Excel can make it easy to highlight payments that are past their due date or to highlight upcoming events with colors changing as the event approaches.

Conditional Formatting Based on a Date
Conditional Formatting Based on a Date

Continue reading Conditional Formatting Based on a Date

How to Apply Conditional Formatting in Excel

A Tutorial on How to Apply Conditional Formatting in Excel

Conditional Formatting is one of the most useful features for making data of a certain criteria really stand out in large spreadsheets.

Conditional Formatting in Excel
Conditional Formatting in Excel

The formatting can be based on the values in a cell – such as a number above or below a certain range – or you can use conditional formatting based on another cell.

Conditional formatting can also be used to highlight dates, text or duplicate values.

To use conditional formatting just select the cells you wish to apply the formatting to and select the Conditional Formatting options from the Styles group on the Home tab of Excel.

Conditional Formatting in Styles Group
Conditional Formatting in Styles Group

Continue reading How to Apply Conditional Formatting in Excel