conditional formatting

Percentage charts with conditional formatting

Percentage charts with conditional formatting

Last week I saw some amazing Excel spreadsheets while I was attending the MVP Summit in Seattle and I thought I’d share some ideas. So here are step by step instructions on how to create a percentage chart with just the Excel grid and a sprinkle of conditional formatting. The goal we’re after looks like [...]

Showcase high and low values in Excel charts – Part 2

Showcase high and low values in Excel charts – Part 2

Introduction In the first part of this mini-series, minimum and maximum values of a chart were showcased by simply sorting the data values in ascending or descending order But… There may be situations, where the order of the data points may not be changed, for example because they are in a chronological order, or because [...]

Conditional formatting for dates in Excel 2007 — that’s not right?!

If you use conditional formatting with Excel 2007 to highlight dates, then you may be in for a surprise in December or January. The conditional formatting with “dates occurring” does not always produce correct results when the year changes. Excel 2007 does not recognise that January follows on December or that December precedes January. A [...]