搜尋
首頁專題excel帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

Struggling to keep your Outlook inbox organized? Learn how to highlight your emails, tasks, meetings and appointments with conditional formatting.

As your inboxes are overflowing with never-ending streams of emails and calendars are packed with numerous appointments, it's easy to feel swamped. However, there's a helpful tool in Microsoft Outlook called conditional formatting. This feature lets you automatically color-code your messages and calendar events based on certain criteria, making it easier to stay organized and focused amidst the chaos.

Note. This article covers conditional formatting in the classic Outlook application. For instructions on how to highlight emails in the new app and Outlook online, please refer to this tutorial: Conditional formatting in new Outlook and on the web.

What is conditional formatting in Outlook?

Outlook conditional formatting allows you to automatically apply specific formatting to emails, tasks and calendar items based on predefined rules or conditions. This functionality goes beyond mere aesthetics - it serves as a visual aid, providing instant insights into the importance, urgency, or nature of each item.

With conditional formatting, you can set up rules that determine how emails, task and calendar entries should be formatted based on various criteria, such as sender, subject, importance, category, or even specific words or phrases. Once these rules are established, Outlook automatically applies the specified formatting whenever an item meets the defined criteria.

For example, urgent emails from a particular sender can be highlighted in red, while messages related to a specific project can be marked with another distinctive color. Likewise, in the calendar, you can assign different colors to appointments that differ in importance, organizer, or attendees to easily recognize significant events and monitor their agendas.

Overall, conditional formatting in Outlook offers visual cues that help you prioritize what matters most, sort everything out, and make good use of your time.

帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

Default conditional formats in Outlook

Microsoft Outlook comes pre-equipped with several color-coding options for emails and tasks, which you might already be using without even realizing it. Here's a rundown of some default formats:

  • Unread - messages that you haven't read yet show up in a bold and blue font.
  • Not Sent - emails that have never been sent are displayed in italics.
  • Expired - messages past their expiration date and completed tasks appear in a grey and strikethrough font.
  • Overdue - messages and tasks that are past a defined due date are highlighted in red.

To view the list of conditional formatting rules that are already in your Outlook, do the following:

  1. Choose the target folder, whether it's emails, tasks, or calendars.
  2. Head to the View tab and click View Settings in the Current View group.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

  3. In the Advanced View Settings dialog box, click Conditional Formatting.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

    You'll see a set of default rules, like the ones for Outlook emails shown here:

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

Any custom rules you've created for this specific view will also be displayed in this dialog box.

Tips:

  • It's not possible to delete the inbuilt rules, but you can temporarily turn them off by clearing the check box for a certain rule.
  • It's not possible to edit the criteria for the default rules, but you can change their formatting to better suit your personal preferences and communication style.

How to color code Outlook emails using conditional formatting

To color code your emails the way you want, you can create a custom conditional formatting rule by following these steps:

  1. Start by choosing the folder where you want to apply the rule, such as Inbox.
  2. On the View tab, in the Current View group, click View Settings.
  3. In the Advanced View Settings dialog box, click Conditional Formatting.
  4. Click the Add button to start creating a new rule.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

  5. In the Name box, type a descriptive name for your rule.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

  6. Click the Font… button to set up formatting for the rule.
  7. In the Font dialog box, select your preferred font color, size, and style, then confirm by clicking OK.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

  8. Click Condition… to specify the criteria under which the rule will be applied.
  9. In the Filter dialog box, you'll be setting the conditions for the rule. There are three tabs here - Messages, More Choices, and Advanced - each offering a variety of options. On the Messages tab, you'll find the most commonly used criteria such as the sender, recipient, subject or message body keywords.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

  10. Click OK three times to close all dialogs and apply the newly created formatting rule.

Done! Your rule is applied immediately, and your inbox is now color-coded according to your specified criteria.

For instance, emails from a specific sender containing the word "important" in the subject line are highlighted in maroon, making them easily recognizable amidst your other messages.

帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

Note. Outlook conditional formatting rules are specific to the view in which you create them. If you want the rule to work for other folders, you can apply the current view to those folders.

How to color code Outlook calendar

If you wish to enhance the organization and clarity of your calendars, you can highlight your meetings and appointments in different colors based on various criteria such as sender, location, attendees, or importance. Here's how to do it:

  1. Select your Calendar folder in Outlook.
  2. Go to the View tab and click View Settings in the Current View group.
  3. In the dialog box that appears, choose Conditional Formatting.
  4. In the Conditional Formatting dialog box, click Add to make a new rule.
  5. Name your rule and pick a color from the Color dropdown.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

  6. Click the Condition… button.
  7. In the Filter dialog box, you can choose from various fields and criteria. For example, to highlight meeting requests from your admin or supervisor, add their email address to the Organize By box.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

  8. For additional options, switch to the More Choices tab. Here, you can set more conditions, such as highlighting appointments and meetings with high importance.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

  9. For even more flexibility, go to the Advanced tab. Then, click on Field > All Appointment Fields and choose the relevant item. For example, to highlight appointments and meetings where you are a required attendee, select All Appointment Fields > Required Attendees.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

  10. In the Value box, type your own name or the name of any other person to whom the criteria should apply, and click Add to List.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

  11. If needed, add more criteria in the same manner. Once done, click OK three times to close all the dialogs and save your rule.

In this example, we've created a formatting rule that highlights calendar items in the teal color when three conditions are met: the appointment or meeting is organized by admin, has high importance, and you (or the specified person) are a required attendee.

Conditional formatting for Outlook tasks

Similar to emails, Outlook offers predefined conditional formatting rules for tasks to help you manage your to-do list more effectively:

  • Complete tasks - appear in grey with a strikethrough to indicate that they've been completed.
  • Overdue tasks – are highlighted in red to draw attention to tasks that are past their due date.
  • Unread tasks - appear in bold to signify tasks that you haven't reviewed yet.

帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

If you're looking to customize the appearance of your tasks for a more visually appealing look, you can add custom conditional formatting rules. The process and options for color-coding tasks are identical to those for emails. Here's a quick rundown of the steps:

  1. Select the tasks folder in your Outlook.
  2. On the View tab, in the Current View group, click View Settings.
  3. In the dialog box that appears, choose Conditional Formatting.
  4. Click the Add button to make a new rule.
  5. Give your rule a name and click Font… to choose the desired formatting.
  6. Click Condition… to open the Filter dialog where you configure the criteria for your rule.
  7. Click OK three times to close all dialog boxes and apply the new rule.

For instance, to highlight high-priority tasks that haven't been started yet, you can set up a rule as follows:

  • First, on the More Choices tab of the Filter dialog, set the importance to "high".

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

  • Then, switch to the Advanced tab and select Field > All Task Fields > Status.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

  • Finally, choose "not started" for the status and add the statement to the list.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

As a result, your high-priority tasks that are yet to be started will be visually distinct, making it easier for you to prioritize and manage your workload.

Examples of Outlook conditional formatting

Now that you've grasped the basics of conditional formatting in Outlook, let's explore some practical examples of color-coding emails.

How to highlight emails from a specific sender

If you want to ensure that messages from a particular sender stand out in your inbox, follow these steps to set up a formatting rule:

  1. Select the Inbox folder or another folder where your ingoing messages are stored.
  2. Open the Conditional Formatting dialog and add a new rule.
  3. On the Messages tab of the Filter dialog, define the criteria for the rule in one of these ways:
    • In the From box, enter the sender's name exactly as it appears in the From field of received emails.
    • Alternatively, type the sender's email address into the From box.
    • If you're in an Exchange environment, click the From… button to select the sender from the Global Address List of your company.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

These steps will help you mark messages from the specified sender with your preferred color, making them easy to identify and prioritize in your inbox.

Tip. It's advisable to base the rule on the email address rather than the sender's name to ensure accuracy. Even a minor discrepancy in the sender's name could prevent the rule from working correctly.

How to color code emails sent to a particular recipient

To make messages sent to a particular person easily distinguishable in your Sent Items folder, create a formatting rule in this way:

  1. Select the Sent Items folder where your outgoing messages are stored.
  2. Open the Conditional Formatting dialog and add a new rule with the following criteria:
    • In the Sent To field, enter the email address of the intended recipient.
    • In an Exchange environment, use the Sent To button to select the recipient from the Global Address List.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

By implementing this rule, messages sent to the specified email address will be highlighted according to your chosen color, enabling you to track the target communications with ease.

How to color code messages containing certain words

Color-coding emails containing specific words can be a helpful way to quickly identify important or relevant communications. Follow these steps to set up a formatting rule:

  1. Select the folder where you want the rule to apply, such as your Inbox or any other designated folder.
  2. Add a new rule with the following criteria:
    • In the Search for the word(s) box, type the particular word or phrase the rule should react to.
    • Use the In dropdown list to define whether to search in the subject, subject and message body, or common text fields.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

This feature is particularly useful for identifying emails related to specific projects or subjects of interest, allowing you to focus on what matters most.

How to color code emails sent only to you

If you're seeking to prioritize messages sent exclusively to you over those received from distribution lists or where you're included on the Cc or Bcc fields, you can highlight such messages by performing these steps:

  1. Select Inbox or any other relevant folder.
  2. Add a new rule and click the Condition… button.
  3. In the Filter dialog box, on the Messages tab, select the Where I am checkbox, and then choose "the only person on the To line" for the criteria.

帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

This way, Outlook will apply the chosen format to any messages that only you receive, helping you in promptly responding to communications that are meant just for you.

How to highlight emails larger than 1MB with attachments

To visually identify large emails with attachments, carry out these steps:

  1. Select Inbox or any other folder where you want the rule to apply.
  2. Add a new rule and click the Condition… button.
  3. In the Filter dialog, switch to the More Choices tab.
  4. Select the Only items with checkbox, and from the dropdown list choose "one or more attachments".
  5. In the Size dropdown list, pick "greater than", and then type 1024 in the box (1024 kilobytes is 1MB).

帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

Once the rule is created, Outlook will automatically apply the specified formatting to any messages larger than 1MB with attachments, making them visually distinct in your inbox.

How to color code not responded meeting requests

To highlight meeting requests that you have not yet responded to, create the following conditional formatting rule:

  1. Select Inbox or any other folder containing meeting requests.
  2. Add a new rule and click the Condition… button.
  3. In the Filter dialog, switch to the Advanced tab.
  4. Click Field and choose All Appointment fields > Meeting Status.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

  5. In the text box under Field, you will see "Meeting Status", with the condition set to "equals". Under Value, select "not yet responded" from the dropdown list, and then click the Add to List button.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

  6. Your statement is now added to the criteria list. Click OK to confirm and close the Filter dialog.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

  7. Click OK again to close the Conditional Formatting dialog.

Outlook will now format any meeting requests waiting for your response with the selected color, making them stand out in your inbox.

How to manage, edit and delete conditional formats in Outlook

To view, modify, or delete conditional formatting rules set for a specific folder in Outlook, follow these steps:

  1. Select the folder of interest. That could be one of your mail folders, tasks or calendars.
  2. Open the Conditional Formatting dialog box: View tab > View Settings > Conditional Formatting.
  3. Select the rule you want to manage and perform one of these actions:
    • Change formatting - click Font, and then choose the color, style, size, and effects you want to use for the rule.
    • Modify criteria - click Condition to edit the criteria for the selected rule.
    • Sort - use the Move Up and Move Down buttons to change the priority in which the rules are applied.
    • Turn off - to temporarily disable a rule, clear the checkbox next to it.
    • Delete - to permanently remove a rule, click the Delete button.

    帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

Note. Default rules have limited customization options. You can only adjust their text formatting, not the criteria. Default rules cannot be deleted, only turned off.

Outlook color-coding tips

Understanding the inner mechanics of conditional formatting in Outlook can improve the consistency and efficiency of your email handling. Here are some helpful tips to help you get the most out of it and avoid any surprises.

Apply conditional formatting rules to multiple folders

Outlook conditional formatting rules work only for folders that have the same view as the folder where the rule is made. To use your rules for other folders, you can copy the current folder's view to other folders of the same kind. For this, choose the target folder, then go to the View tab and click Change View > Apply Current View to Other Mail Folders. To apply the view for all subfolders, select the corresponding checkbox. Please remember that special folders like Sent Items, Drafts, and Junk have their own views and cannot get the current view applied.

帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務

Specify emails rather than names

For the conditional formats to work correctly, it's crucial that the name specified in the rule precisely matches the display name in the message. Therefore, when specifying names of senders or recipients, accuracy is key. A more reliable approach is to base the rule on the email address or select senders/recipients from the Global Address List.

Properly arrange the rules

Sorting rules using the Move Up and Move Down buttons affects the order in which the rules are applied. Higher listed rules take precedence over lower ones.

For example, suppose you have two custom rules for messages from the same sender, say Jane, with different formatting. Rule 1 highlights all emails in purple and rule 2 highlights unread messages in fuchsia. If rule 1 is listed above rule 2, all messages from Jane will be purple.

Avoid creating too many rules

Using too many colors might make things messy instead of organized. So, be selective and avoid overwhelming your mailbox with excessive color-coding. It's better to keep things simple and clear.

To sum up, learning how to use conditional formatting in Outlook can really make a difference in how you manage your emails and schedule. By following our simple tips, you can keep your inbox organized, stay on track with your tasks, and avoid getting overwhelmed. Just remember to keep things simple and not go overboard with too many color codes.

以上是帶有條件格式的顏色代碼Outlook電子郵件,日曆和任務的詳細內容。更多資訊請關注PHP中文網其他相關文章!

陳述
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn
Excel中的中位公式 - 實際示例Excel中的中位公式 - 實際示例Apr 11, 2025 pm 12:08 PM

本教程解釋瞭如何使用中位功能計算Excel中數值數據中位數。 中位數是中心趨勢的關鍵度量

Google電子表格Countif函數帶有公式示例Google電子表格Countif函數帶有公式示例Apr 11, 2025 pm 12:03 PM

Google主張Countif:綜合指南 本指南探討了Google表中的多功能Countif函數,展示了其超出簡單單元格計數的應用程序。 我們將介紹從精確和部分比賽到Han的各種情況

Excel共享工作簿:如何為多個用戶共享Excel文件Excel共享工作簿:如何為多個用戶共享Excel文件Apr 11, 2025 am 11:58 AM

本教程提供了共享Excel工作簿,涵蓋各種方法,訪問控制和衝突解決方案的綜合指南。 現代Excel版本(2010年,2013年,2016年及以後)簡化了協作編輯,消除了M的需求

如何將Excel轉換為JPG-保存.xls或.xlsx作為圖像文件如何將Excel轉換為JPG-保存.xls或.xlsx作為圖像文件Apr 11, 2025 am 11:31 AM

本教程探討了將.xls文件轉換為.jpg映像的各種方法,包括內置的Windows工具和免費的在線轉換器。 需要創建演示文稿,安全共享電子表格數據或設計文檔嗎?轉換喲

excel名稱和命名範圍:如何定義和使用公式excel名稱和命名範圍:如何定義和使用公式Apr 11, 2025 am 11:13 AM

本教程闡明了Excel名稱的功能,並演示瞭如何定義單元格,範圍,常數或公式的名稱。 它還涵蓋編輯,過濾和刪除定義的名稱。 Excel名稱雖然非常有用,但通常是氾濫的

標準偏差Excel:功能和公式示例標準偏差Excel:功能和公式示例Apr 11, 2025 am 11:01 AM

本教程闡明了平均值的標準偏差和標準誤差之間的區別,指導您掌握標準偏差計算的最佳Excel函數。 在描述性統計中,平均值和標準偏差為interinsi

Excel中的平方根:SQRT功能和其他方式Excel中的平方根:SQRT功能和其他方式Apr 11, 2025 am 10:34 AM

該Excel教程演示瞭如何計算正方根和n根。 找到平方根是常見的數學操作,Excel提供了幾種方法。 計算Excel中正方根的方法: 使用SQRT函數:

Google表基礎知識:了解如何使用Google電子表格Google表基礎知識:了解如何使用Google電子表格Apr 11, 2025 am 10:23 AM

解鎖Google表的力量:初學者指南 本教程介紹了Google Sheets的基礎,這是MS Excel的強大而多才多藝的替代品。 了解如何輕鬆管理電子表格,利用關鍵功能並協作

See all articles

熱AI工具

Undresser.AI Undress

Undresser.AI Undress

人工智慧驅動的應用程序,用於創建逼真的裸體照片

AI Clothes Remover

AI Clothes Remover

用於從照片中去除衣服的線上人工智慧工具。

Undress AI Tool

Undress AI Tool

免費脫衣圖片

Clothoff.io

Clothoff.io

AI脫衣器

Video Face Swap

Video Face Swap

使用我們完全免費的人工智慧換臉工具,輕鬆在任何影片中換臉!

熱工具

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

這個專案正在遷移到osdn.net/projects/mingw的過程中,你可以繼續在那裡關注我們。 MinGW:GNU編譯器集合(GCC)的本機Windows移植版本,可自由分發的導入函式庫和用於建置本機Windows應用程式的頭檔;包括對MSVC執行時間的擴展,以支援C99功能。 MinGW的所有軟體都可以在64位元Windows平台上運作。

mPDF

mPDF

mPDF是一個PHP庫,可以從UTF-8編碼的HTML產生PDF檔案。原作者Ian Back編寫mPDF以從他的網站上「即時」輸出PDF文件,並處理不同的語言。與原始腳本如HTML2FPDF相比,它的速度較慢,並且在使用Unicode字體時產生的檔案較大,但支援CSS樣式等,並進行了大量增強。支援幾乎所有語言,包括RTL(阿拉伯語和希伯來語)和CJK(中日韓)。支援嵌套的區塊級元素(如P、DIV),

SecLists

SecLists

SecLists是最終安全測試人員的伙伴。它是一個包含各種類型清單的集合,這些清單在安全評估過程中經常使用,而且都在一個地方。 SecLists透過方便地提供安全測試人員可能需要的所有列表,幫助提高安全測試的效率和生產力。清單類型包括使用者名稱、密碼、URL、模糊測試有效載荷、敏感資料模式、Web shell等等。測試人員只需將此儲存庫拉到新的測試機上,他就可以存取所需的每種類型的清單。

EditPlus 中文破解版

EditPlus 中文破解版

體積小,語法高亮,不支援程式碼提示功能

DVWA

DVWA

Damn Vulnerable Web App (DVWA) 是一個PHP/MySQL的Web應用程序,非常容易受到攻擊。它的主要目標是成為安全專業人員在合法環境中測試自己的技能和工具的輔助工具,幫助Web開發人員更好地理解保護網路應用程式的過程,並幫助教師/學生在課堂環境中教授/學習Web應用程式安全性。 DVWA的目標是透過簡單直接的介面練習一些最常見的Web漏洞,難度各不相同。請注意,該軟體中