Free Online Microsoft Training

Free tips and tricks for using Microsoft Office and Windows

Free Online Microsoft Training

Free tips and tricks for using Microsoft Office and Windows

How to apply conditional formatting to an entire row based on dates older than today

How to apply conditional formatting to an entire row based on dates older than today

It seems my conditional formatting posts have become quite popular and with that, I’ve had some amazing questions asked about variations of how to use conditional formatting. One such question was how to apply conditional formatting to an entire row in Excel. The approach for this one is a little bit different but works amazingly. […]

Use conditional formatting to identify dates within a specific range

Use conditional formatting to identify dates within a specific range

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

Use conditional formatting to identify dates older than today

Use conditional formatting to identify dates older than today

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

How to use conditional formatting in Excel

How to use conditional formatting in Excel

Conditional formatting in Excel is one of my favourite features to use. I am a very visual person and would much rather look at colour charts or visual representations of data to give me a sense of what I’m looking at. Conditional formatting is the easiest way to achieve this result. I am always surprised […]