Many Access users would like to highlight report information, conditionally; similar to the way Excel users employ conditional formatting. For instance, the simple report shown below displays a due ...

Have you ever spent hours perfecting your Excel spreadsheet, only to watch your carefully crafted formatting fall apart the moment you insert a new row? It’s a maddeningly common issue for Excel users ...

Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.

Software engineer Chandoo shares some Excel conditional formatting tricks that make for good-looking and useful spreadsheets, like a Gantt chart. Conditional formatting makes a cell look a certain way ...

It’s not hard to add an alternating band format to a table by applying a table style. It’s quick and easy, but it’s limited. You’ll get a single-row fill color that alternates with a row of white (or ...

Use Google’s dedicated timeline engine to build professional, self-updating interactive project trackers in minutes.

Quip, a startup with mobile apps for crafting and collaborating on documents, has turned on some useful capabilities when it comes to working with spreadsheets. Now you can click a couple of buttons ...

This is the demonstration file to accompany the article, How to add visual insight to data by applying conditional formatting to a table or matrix visualization in Microsoft Power BI by Susan Harkins.