How to use Countif in Excel

How to use Countif in Excel

When working with large amounts of data in Excel, you can find yourself needing to count the number of records which meet specific criteria. This is when the Countif function in Excel is going to come in very handy and save you a lot of time. Let’s take a look at how Countif works and […]

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

Conditional formatting an entire row

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. If you haven’t already taken a look at my other conditional formatting posts, be sure to explore how to use conditional formatting with dates based on a range, […]

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