Tuesday, April 13, 2021
Home Excel Methods Conditional Formatting

Conditional Formatting

Conditional reporting can often seem like magic. These posts and articles show conditional reporting in action.

To use Account Groups in Excel formulas, you first must define the groups. Here’s how to do it using either simple lists or Dynamic Arrays.

How to Define General Ledger Account Groups in Excel

In Part 1 of this series, How to Report GL Account Groups in Excel, we explored the strategy for creating financial reports that use...
A manager needs to assign employee color codes to various tasks they perform for customers. Here's one way to do it with Excel's conditional formatting.

Use Conditional Formatting with Formulas to Manage Employee Tasks

"I have a simple Excel sheet with a list of to-do items down the left hand column. I have clients along the top. For...
Here's how to use a formula that returns TRUE or FALSE in Excel's conditional formatting feature to highlight rows that contain specific numbers or text.

How to Use Conditional-Format Formulas to Change Background Colors

"I have an Excel table with a column that will be filled with 'yes' or 'no. When a user enters 'yes' to a cell,...
When you combine conditional formatting with charts you can create detailed chart legends that match the relative positions of the lines in your chart.

How to Create Dynamic Chart Legends in Excel

When I saw a chart designed like the ones below in the Wall Street Journal, I knew I had to create one just like...
Here's how to use formulas and conditional formatting to expand or contract your Excel report automatically, without macros, when you change a cell value.

Create Variable-Length, Dynamic Reports Linked to Excel Tables

Excel Tables are a powerful feature introduced in Excel 2007. Not only can you report from them directly, you can use them as a...
Conditional formatting with formulas offers power and flexibility for your Excel reports. Here's how to get started.

Conditional Formatting with Formulas

Excel offers two types of conditional formatting. Although both types are very useful, one of them is more widely used than the other…probably because...

Latest Articles

Using Excel's LET, SORTBY, and SEQUENCE functions, and dynamic arrays, you easily can list any number of top and bottom results from a Table.

How to Report Top and Bottom Results Using Dynamic Arrays in Excel

In How to Use Excel’s LET Function, I showed several examples of a powerful function that Microsoft added to Excel 365 in the summer...
The LET function is the most powerful function that Microsoft has released for Excel in years. Here's an introduction to its features.

How to Use Excel’s LET Function

In the summer of 2020, Microsoft introduced the LET function for Excel 365—one of the most-significant new worksheet functions that Microsoft has introduced in...
You can ratchet down errors in your Excel reports by using an Error Summary Table that uses conditional formatting to alert you to errors.

How to Set Up an Automatic Error-Checking System in Excel Reports

Decades ago, I worked as a cost accountant for a large company. But because our department received terrible reports, I wrote my own reports...using...