How Conditional Formatting Highlight Emails in Outlook [Based on Specific Requirement]

Working on huge data required some basic tools to filter or classified data in the group, the result must be fruitful. Microsoft Outlook conditional formatting is one of the intelligent tools which identifies your requirement and handles the email message accordingly.

In this article, you will learn auto highlight emails in outlook based on the specific requirement.

What is a primary benefit of conditional formatting in Outlook?

Conditional formatting is an internal algorithm based on certain rules, which helps the user to get better results. You can also apply rules resulting based on their properties (like the sender, subject line, or timestamp).

The Conditional Formatting feature manages all your Emails, Calendar items, Contacts, and Tasks and arranges them according to color coding without the need to apply a Color Category to it or move them to different folders.

How To Automatically Highlight Emails in Outlook? [based on period]

In case you want to highlight emails based on specific date range, conditional formating comes into play, Here you can follow the step by step process to understand the key formula to highlight email messages according to their age.

  • Shoot Outlook and switch to “View” tab
  • Click Change view >> “Manage views”

Manage view outlook

  • Manage all view dialog box pops up >> Click New button >> this will take you to Create a New View dialog box.

How To Automatically Highlight Emails in Outlook

  • Name your new view text box in the Create a New View dialog box, >> Select All Mail and Post folders (IMAP), and hit OK.
  • Advanced View Settings dialog box appears with that same name, Now press the conditional formating button to create the conditional format.

Conditional formatting outlook

  • A conditional formatting dialog box appears, there are few by default rules available, in the current scenario, Hit outlook conditional formattingAdd.
  • Name your Rule – “Mail Smartly”, click the font button, and a font dialog box displayed, you can adjust (fonts, fonts style, size, effects, color, script) according to your choice, your select, after all, adjustments will separate email messages.

how to color code emails in outlook

  • The next step is to click condition, the most important step for auto highlight emails in outlook, clicking on the condition “FILTER” dialog box pops up.

There are multiple options in the filter dialog box [messages, more choice, and advance]. In this case, follow these steps:

  • Hit Advanced tab >> Click Field button >> Select Frequently-used fields from the drop-down list.

Frequently used fields

  • Under the ‘Frequently used field’, you can find multiple options every option open a gate of strategy, in our case you have to select ‘received’.

strikethrough in outlook

  • The next step is to select the condition, you again have multiple options of time criteria under the condition drop-down list.

The choices are much greater than you might expect:

  1. Anytime
  2. Yesterday
  3. Today
  4. Tomorrow
  5. In the last 7 days
  6. In the next 7 days
  7. Last Week
  8. This Week
  9. Next Week
  10. Last Month
  11. This Month
  12. Next Month
  13. On
  14. On or before
  15. Between
  16. Exists
  17. On or after
  18. Does not exist
  • Select ‘between’ and type manually in the value section “4 months ago and 6 months ago”.

[Note: You can select a condition and enter value comment manually according to your search criteria.]

Auto highlight emails based on age in Outlook

  • Finally, click the ‘Add to List’ button. Your criteria added in the above list. Click OK.

Everything is set, follow the step to take a look of your result:

  • Click View Tab >> Change View >> you can find another view option which you have created earlier in the article >> Click to that.

outlook conditional formatting not working

  • You can check scrolling down the change of color of your email message based on their age [which you have specified in the filter option above]. The result is impressive. Now the outcome varies, the emails enter that barrier automatically change the color, and the email step out of that barrier changes itself to the original view.

how to strikethrough in outlook

How To Change Color of Receiving Email in Outlook? [From Specific Email Address/Person]

Searching Email received from a specific email address or person in Outlook is not rocket science, the search bar can handle it. All you have to know the exact method to find the emails.

Outlook conditional formatting based on email domain not only grabs those emails but also changes the format or color as per your choice.

How to Create a Conditional formatting rule?

Walk me through the step by step tutorial:

  • Lunch Outlook >> Click View Tab >> View Setting.

Create a Conditional formatting rule

  • Click Conditional formating for imposing specific conditions (changing color of an email received from certain email addresses or persons) and format the inbox.
  • Click Add and enter the name of your formatting rule. Name your rule & Hit font, change the font, style, effects, and color according to your choice.

Conditional Formatting button Outlook

  • Click Condition, Type the address or part of the address in the From field on the Messages tab. For instance: we required to highlight all messages from instamojo.com.

Conditional formatting rule Outlook

  • Hit Ok and close the dialog box, and the expected results are incredible, colored email messages from the desired server name in your inbox are clearly visible. [Refer: Snapshot]

create a conditional formatting rule in outlook

How to Delete Conditional Formatting Rule?

If you no longer required a specific conditional formatting rule function, you can easily delete the rule and everything works as normal. In the Conditional Formatting window, select the rule you want to delete and click the Delete button. [refer:image]

How to Delete Conditional Formatting Rule

Conditional Formatting in Microsoft Outlook is another great feature similar to “Rule”, which deliver more than expected to their user. I always recommend to try this feature and enjoy the full strength of Microsoft Office Outlook 365.

There are tons of conditional formatting rules in outlook which really works for you.

Related Articles

Leave a Comment