Change Excel Fonts and Colors with Conditional Formatting


show more Using conditional formatting to change font and color provides you with in-depth training on Business. Taught by Jess Stratton as part of the Outlook 2013 Essential Training show less
please wait ...

Using conditional formatting to change font and color

We all organize differently. Some of us are visual, some of us are sorters. Putting messages in a folder may work for some people, while others need to see everything in the inbox. For those people, we can change the color of emails on a conditional basis. For example, any email from a certain sender or containing a certain subject line or words in the body of the email. Now we can do this with categories, which we will talk about in a later video, but for this one, I wanted to show you how to use conditional formatting to actually change things in your inbox.

Now for this example, I want to take all my emails that come to me with the words New product release in the subject line, because I want to know about it. I am going to change the way it looks by making it red and bold. So we do that by going over the View Ribbon tab, going over to View Settings, and selecting Conditional Formatting. Now from here, I can go and look at all my views. These are the existing ones and I can create my own....

Using conditional formatting to change font and color
Video duration: 3m 53s 3h 6m Appropriate for all

Viewers:

Using conditional formatting to change font and color provides you with in-depth training on Business. Taught by Jess Stratton as part of the Outlook 2013 Essential Training

Subjects:
Business Education + Elearning
Software:
Outlook
Author:
please wait ...