Conditional Formatting in Outlook

Conditional Formatting in Outlook

Many users have discovered the amazing conditional formatting functions available in Excel, but not many know that you can also use conditional formatting in Outlook. This feature allows you to specify rules based on your incoming email messages so that you can change the formatting as they arrive. Want to make all emails from “Bob” […]

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

Use conditional formatting to identify dates older than today

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

How to copy formatting using Format Painter

How to copy formatting using Format Painter

Each of the Microsoft programs includes some basic clipboard options which incorporate the Cut, Copy and Paste functions. Generally users are pretty familiar with these tools. What many users have not utilised is the fourth function in the group called Format Painter. Format Painter is a quick and easy way to copy the formatting from […]

Introduction to Styles in Word

Introduction to Styles in Word

Today I’m going to provide an introduction to the styles feature available within Microsoft Word. Working with a document is not only about entering the content, but also about making that content easy to read and understand. One of the ways you can achieve this is through the formatting of text and elements within the […]

How to use conditional formatting in Excel

Conditional Formatting Excel

Conditional formatting is one of my favourite parts of Excel. 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 how often […]