How to show duplicates in Excel
A very common request in any of my Excel courses is “how to show duplicates in Excel”. When we are working with any data set you may need to be alerted when duplicate records exist. This process is surprisingly simple to set up and have Excel alert you with a change in formatting when a […]
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
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 […]
Excel Conditional Formatting Based on Dates (Highlight Older Than Today)
During a Microsoft Excel training session a few week’s ago, I had a great question about using conditional formatting based on dates, in particular 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 […]
How to use conditional formatting in Excel
Conditional formatting in Excel is one of my favourite features. 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. In this post you’ll learn how to apply basic conditional formatting rules, how to customise them, […]