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...
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...
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...
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...
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...
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,...
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...
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
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...