conditional formatting

Fibonacci Clock with Excel – no code

Fibonacci Clock with Excel – no code

The Fibonacci Clock is getting quite some attention on the web lately. Check it out here and read about how it works. Short summary: The clock consists of five squares with different magnitudes: 5 – 3 – 2 – 1 and 1 again. Add up the magnitudes for the red and the blue squares to arrive [...]

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