How to conditionally format your Outlook emails. Now that you know the basics, we can go further and tackle the 'conditional formatting' problem:) Here is the text in question: Dear all, I am writing to remind you about the deadline for your projects. You should be done with them in 14 days / in 7 days / tomorrow. Conditional Formatting for Outlook 2019 for Mac I have recently upgraded to Office 2019 for Macs and am looking for the conditional formatting option in Outlook? Is this no longer an option?

I like my calendars to be color-coded. It looks nice, and when you have a busy week it just helps make sense of your calendar at a glance. You can use conditional formatting in Outlook to automatically assign colors to calendar items using conditions that you create. This really takes the work out of color-coding your calendar!

Open the Calendar View Settings by going to the Calendar in Outlook, then selecting the View tab, then “View Settings”:

Select Conditional Formatting:

Click “Add” to create a rule. Give it a name and color for the calendar items. Select Condition to create the rule needed to color-code the meeting:

In this example, I want calendar items containing “PTO” to be teal, so I just used the keyword search in the condition window:

That’s all I need for this rule, but check out the other tabs to get a feel for the conditions you can create:

I created a calendar item called “PTO”, and sure enough, it was assigned the color teal immediately:

The Conditional Formatting feature in Outlook allows you to get organized by automatically color coding your Emails, Calendar items, Contacts and Tasks without the need to apply a Color Category to it or move them to different folders.

The color coding isn’t just intended to emphasize certain emails but it can also be used to deemphasize certain emails such as newsletters or emails you are only a CC or BCC recipient of.

You may actually already know Conditional Formatting without realizing it as it is for instance also being used to:

• Show unread emails in a blue and bold font.
• Show expired emails and completed tasks in a grey and strikethrough font.
• Show overdue emails and tasks in a red font.

The “Conditional Formatting” feature may look complex at first but creating color coding rules is actually fairly easy and quite powerful when used the right way.

This guide will help you on your way to get yourself familiar with the Conditional Formatting options with 8 color coding examples which might be useful to you as well.

Conditional Formatting usage in the Message List.

Conditional Formatting Basics

Creating a Conditional Formatting rule can be done in the following way;

1. Open the Conditional Formatting dialog:
   • Outlook 2007
     View-> Arrange By-> Custom…-> Automatic Formatting…
   • Outlook 2010 / 2013 / 2016 / 2019 / Microsoft 365
     tab View-> View Settings-> Conditional Formatting…

2. To define a Conditional Formatting rule of your own, press the Add button.

   
   Adding a new Conditional Formatting rule.

3. Supply a name for the rule.
4. Press the Font… button to define your Font settings.
5. Press the Condition… button to specify when this font should apply.

You may recognize the Condition… dialog and its usage as the same dialog is used to create a Search Folder, a View Filter or to perform an Advanced Search.

Conditional Formatting Tips & Tricks

Just like many other “more advanced” features in Outlook, the Conditional Formatting feature may sometimes appear to have a mind of its own and produce unexpected results or no results at all.

The tips and tricks below will help you better understand how the Conditional Formatting feature works and generate its color coded view.

• You can sort the rules by using the “Move Up” and “Move Down” buttons. The higher listed rules takes precedence over the lower ones. A lower listed rule can append the formatting of a higher listed rule if the formatting is not defined.
  • For instance, when in a higher listed rule the font color is set to “Auto” the color of a lower rule will apply. However, if the higher listed rule has a color defined, the lower rule will not “overwrite” this color.
• Specifying names of senders or recipients in a Conditional Formatting rules can be a bit tricky; The name must exactly match the name as displayed in the From field of the message. Better is to create the rule based on the e-mail address. If you are in an Exchange environment, you can simply add the names as listed in the Global Address Book of your company.
• The Conditional Formatting rule only applies to the folders which use the same view. To apply your custom view to other folders see: Applying custom views to all folders at once.
• If the rule doesn’t do what you expect it to do once created, you might want to try to remove or even isolate statements (by creating a separate rule for that statement) to find out where things go wrong.
• Do not add too much color to your mailbox or the organizing effect gets lost (but you’ll be left with a nice rainbow though ).

Conditional Formatting Examples

I’ll explain the advanced color editing by the following examples/ideas. The examples are getting more advanced each time so when you’ve practiced them all you should be able to handle it as a pro as you are not limited to these examples;

Example 1: Color code messages coming from someone specific (like your partner)

1. Open the Conditional Formatting dialog, add a new rule, name it, specify a font and press the Condition… button.
2. In the “From” field, type the email address of the sender or (when you are in an Exchange environment), press the From… button and select the sender from the Global Address List (so not your Contacts folder as explained here).
3. Press OK to close the Filter dialog.
4. Press OK to close the Conditional Formatting dialog. Your rule will apply immediately to al messages already received which correspond to the rule just created.

Color code messages coming from a specific address.

Example 2: Color code messages that are sent to a specific email address

1. Open the Conditional Formatting dialog, add a new rule, name it, specify a font and press the Condition… button.
2. In the “Sent To” field, type the email address of the recipient or (when you are in an Exchange environment), press the Sent To… button and select the recipient from the Global Address List (so not your Contacts folder as explained here).
   • This rule can be useful to highlight that the email was also sent to for instance your manager or a colleague, a distribution group or to a newsletter alias.
3. Press OK to close the Filter dialog.
4. Press OK to close the Conditional Formatting dialog. Your rule will apply immediately to al messages already received which correspond to the rule just created.

Color code emails that were sent to a newsletter alias.

Example 3: Color code messages by words in the message

1. Open the Conditional Formatting dialog, add a new rule, name it, specify a font and press the Condition… button.
2. In the “Search for the word(s)” field add the words Conditional Formatting should respond on.
3. By the “In” dropdown list you can specify whether to look in Subject, Subject and Body or common mail fields (like From or Category).
4. Press OK to close the Filter dialog.
5. Press OK to close the Conditional Formatting dialog. Your rule will apply immediately to al messages already received which correspond to the rule just created.

Outlook For Mac Conditional Formatting Excel

Color code messages based on the word “dispatched”.

Example 4: Color code messages by Category

1. Open the Conditional Formatting dialog, add a new rule, name it, specify a font and press the Condition… button.
2. Press the More Choices tab.
3. Press the Categories… button.
4. Select the categories you want Conditional Formatting to apply to. When you are done selecting categories press OK.
5. Press OK to close the Filter dialog.
6. Press OK to close the Conditional Formatting dialog. Your rule will apply immediately to al messages already received which correspond to the rule just created.

Color code messages based on Categories.

Example 5: Color code messages when the message is larger than 1MB and contains specific words

1. Open the Conditional Formatting dialog, add a new rule, name it, specify a font and press the Condition… button.
2. In the “Search for the word(s)” field add the words Conditional Formatting should respond on.
3. By the “In” dropdown list you can specify whether to look in Subject, Subject and Body or common mail fields (like From or Category).
4. Press the More Choices tab.
5. At the bottom, in the Size section, press the down arrow where now “Doesn’t matter” is displayed and set it to “Greater than”.
6. One text area will become active now. In this window type 1024 (1024 kilobytes is 1MB).
7. Press OK to close the Filter dialog.
8. Press OK to close the Conditional Formatting dialog. Your rule will apply immediately to al messages already received which correspond to the rule just created.

Outlook For Mac Conditional Formatting Example

Color code messages based on their size.

Example 6: Color code messages received today, addressed directly to me coming from specific persons

1. Open the Conditional Formatting dialog, add a new rule, name it, specify a font and press the Condition… button.
2. At the bottom next to Time press the down arrow, where now “none” is displayed, and set it to “received”.
3. The dropdown list next to “received” will now become active and is set to “anytime” by default. Set this to “today”.
4. In the Sent To… field type your e-mail address. If you’ve got more than one e-mail address configured in Outlook you can enter here more than one e-mail address. When specifying more than 1 address, make sure you divide them with an ” ; “.
   • Example
     address1@domain1.com; address2@domain.com; address1@domain2.com. Please mind the rules about using the Sent To… button; read them here.
5. In the From… field type the addresses of the people you want Conditional Formatting to respond to. Again; mind the rules about using the From… button
6. Press OK to close the Filter dialog.
7. Press OK to close the Conditional Formatting dialog. Your rule will apply immediately to al messages already received which correspond to the rule just created.

Color code messages based on the From, To and Received fields.

Example 7: Color code messages that have a Receipt Request and is considered Confidential

1. Open the Conditional Formatting dialog, add a new rule, name it, specify a font and press the Condition… button.
2. Press the tab Advanced.
3. Press the Field button.
4. Navigate to and select All Mail Fields-> Receipt Requested.
5. You’ll now see “Receipt Request” in the text box under Field and next to it (under Condition) you’ll see a dropdown list set to “equals to” and next to that (under Value) you’ll see a dropdown list set to “no”. Set this value to “yes”.
6. Press the “Add to List” button. The statement is now added to the “Find items that match these criteria:” list.
7. Again press the Field button.
8. Navigate to and select Frequently-used fields-> Sensitivity.
9. You’ll now see “Sensitivity” in the text box under Field and next to it (under Condition) you’ll see a dropdown list set to “equals to” and next to that (under Value) you’ll see a dropdown list set to “normal”. Set this value to “confidential”
10. Press the “Add to List” button. The statement is now added to the “Find items that match these criteria:” list so you’ll now see both statements just created.
11. Press OK to close the Filter dialog.
12. Press OK to close the Conditional Formatting dialog. Your rule will apply immediately to al messages already received which correspond to the rule just created.

Color code messages based on multiple Advanced filter fields.

Example 8: Color code a Meeting Request you have not yet responded to

1. Open the Conditional Formatting dialog, add a new rule, name it, specify a font and press the Condition… button.
2. Press the tab Advanced.
3. Press the Field button.
4. Navigate to and select All Appointment fields-> Meeting Status.
5. You’ll now see “Meeting Status” in the text box under Field and next to it (under Condition) you’ll see a dropdown list set to “equals to” and next to that (under Value) you’ll see a dropdown list set to “Meeting organizer”. Set this value to “not yet responded”.
6. Press the “Add to List” button. The statement is now added to the “Find items that match these criteria:” list.
7. Press OK to close the Filter dialog.
8. Press OK to close the Conditional Formatting dialog. Your rule will apply immediately to al messages already received which correspond to the rule just created.

Color code Meeting Requests you haven’t yet responded to.

Well that should be it! You are now able to create rules with combined types of conditions. Again; If the rule doesn’t do what you expect it to do once created you might want to try to remove or even isolate statements (by creating a separate rule for that statement) to find out where things go wrong.

Links to more Conditional Formatting examples

Do you want more examples of how Conditional Formatting can be useful to you?

The links below contain many more scenarios for which you can use Conditional Formatting like for instance to Color Code your Calendar without the need to use Color Categories (which people you share your Calendar with may not see).

Conditional Formatting in the Calendar.