formatting

Conditional Format to highlight a date 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 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 …

Use conditional formatting to identify dates within a specific range Read More »

Share this:
Conditional Format Dates

Use conditional formatting to identify dates earlier 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 …

Use conditional formatting to identify dates earlier than today Read More »

Share this:
Copy formatting using Format Painter

Copy formatting using Format Painter

Whenever I conduct a training course in any of the Microsoft products, I always touch on the Clipboard group of tools. These include the Cut, Copy and Paste functions and almost all users have some type of experience using these tools. What many users have not utilised is the fourth little icon in this group …

Copy formatting using Format Painter Read More »

Share this:
Scroll to Top