No matter how much we think we know Excel, we still come across new things all of the time. This is one a client showed me the other da...

I've just got another short post for you this week, that's a follow-up to a post I wrote a few years' back. Back in 2009, I...

Just a short post this week, as I have a pretty manic workload at the moment! A few years ago, I did a post on using Data Validation to...

Excel's conditional formatting feature typically allows you to set the format of a cell based upon its contents, and allows you to de...