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

Build stable, high-performance dashboards using REPT formulas and UNICHAR symbols instead of conditional formatting.

Last year, I showed you a dynamic approach to using conditional formatting to highlight weekends in a monthly matrix-style calendar. In that article, "Use Excel's conditional formatting to highlight ...

This week's tutorial covers a number functions in Google's Spreadsheet app, Google Sheets. Here we take a practical look at using weekdays in calculations, introduce "if" statements and learn how to ...

This week's tutorial covers a number functions in Google's Spreadsheet app, Google Sheets. Here we take a practical look at using weekdays in calculations, introduce "if" statements and learn how to ...

For you advanced users who want to skip ahead: You apply the conditional formatting using a custom formula and some variation on the INDIRECT function. In addition to specifying the column and row, ...

Create a self-updating Excel checklist with checkboxes, IFS due-date priority, and a progress data bar for faster tracking.

How to avoid a conditional formatting rule in Excel that doesn’t work as expected Your email has been sent Microsoft Excel’s conditional formatting is a flexible tool that applies formatting on the ...

Dynamically visualize your data.

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