Sunday, October 25, 2020
Home Excel Methods Conditional Formatting

Conditional Formatting

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

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

Here's how to boost your Excel output, slash your Excel errors, and improve your Excel reports and analyses—whether you work for a large or small company.

How to Be Significantly More Productive in Excel

The Excel charts below are professional-quality. But that's not what makes them so unusual. Instead... ● You can update them in a few seconds, with...
Use this Excel dashboard to track 27 economic indicators of the United States' recovery from the Covid-19 recession.

Learn How to Use Excel to Track the US Recovery from the Covid Recession

The Covid recession is the worst recession the world has experienced since the Great Depression. And the Recovery Tracker workbook and Excel training can...
This Excel dashboard report lets you follow key economic trends while showing you how to gain a HUGE increase in your Excel productivity at work.

Track Key Economic Indicators Every Weekday with this Excel Dashboard

You can update this Excel dashboard report every weekday—with one command—if you have Excel 2016 or above. This report of current economic data introduces you...