Skip to content
Archive of posts tagged Conditional Formatting

Worksheet as a chart – multiple conditional formats

Several years back, I wrote an article on how to use multiple cells to simulate conditional formats that involved more than 3 conditions. Three versions of Excel later, I still receive requests related to this post. So, I updated it to include more screenshots and a downloadable file. In Excel 2003 and earlier, conditional formatting […]

Create a dynamic range reference

One of the most common issues that arise in Excel is that a range that contains data will eventually expand as more data are added or even contract as data are removed. If we have a formula, or an Excel functionality (such as Data Validation or a PivotTable), or a chart, that refers to such […]

Ordinal Numbers Suffixes

Starting with Excel 2007, it is possible to specify the number format as part of conditional formatting. This note shows how to leverage that capability to add the appropriate suffix to an ordinal number (e.g., 1st, 2nd, 3rd, 4th, etc.) For a version in a page by itself (i.e., not in a scrollable iframe as […]