Tuesday, December 10, 2024
Home Excel Methods Conditional Formatting

Conditional Formatting

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

How to Set Up Multiple Conditional Formats with Formulas

In How to Set Up a Square-Format U.S. Map in Excel, I showed how to create a square-format US map in Excel. I also...
When conditional formatting rules conflict, Excel can deliver unexpected formatting results. These two guidelines make Excel's logic clear.

How Excel Manages Conflicting Conditional Formats with Formulas

When we're working with conditional formatting with formulas, how does Excel manage conditional formatting rules that conflict with each other? And how does the "Stop...
This Excel map relies on conditional formatting to highlight areas of interest.

How to Set Up a Square-Format U.S. Map in Excel

For several years, the Wall Street Journal has occasionally used a square-format US map like the following image. But when I noticed a recent...
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

0
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

0
"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

0
"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

0
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

0
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

0
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

Excel Flowbook Revolution

Getting Radical with Excel

It's time to think about Excel in a radical new way—when we use it to work with business or economic data. It's time, in fact,...
Growing too fast can be dangerous to your company's health. Use the Sustainable Growth Rate ratio to track your company's financial ability to grow.

How Fast Is Too Fast?

(Originally published in Inc Magazine.) What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...

How to Smooth Data by Using the TREND Function

0
Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...
Advertisement