Use conditional formatting to identify dates within a specific range

Conditional Formatting date ranges

My conditional formatting to identify dates earlier than today post has proven to be extremely popular. This post talks about how to conditional format dates within occur in the past. I have had plenty of questions and comments based on this post. A popular question is how to use conditional formatting to highlight a date […]

How to display a second time zone in your Outlook Calendar

How to add a second time zone to your Outlook Calendar

For anyone with friends, relatives or colleagues living in a different time zone, it can be a fun maths game to work out what the time is where they are located. Personally I’m having to do this now after a close family friend moved from Sydney to Scotland. Those first few weeks of trying to […]

Use conditional formatting to identify dates earlier than today

Conditional Format Dates

During a Microsoft Excel training session a few week’s ago, I had a great question about using conditional formatting to highlight dates earlier than the current one, in other words, how can we highlight dates that occur in the past? This was a great question and so I thought I would publish a post this week about how […]