How to Fix Outlook Conditional Formatting for Completed Messages
Question details
The user wants to configure conditional formatting in Outlook to apply specific colors to completed messages and needs to resolve conflicts between overlapping formatting rules.

- Product
- Microsoft Outlook
- Device & OS
- not provided
- Scenario
- Setting up custom color codes for incoming, read, flagged, and completed messages in the inbox.
- Observed behavior
- Conditional formatting fails to color completed messages correctly because rule order and overlapping conditions cause one color rule to override another.
Ensure you are using the desktop version of Microsoft Outlook, as advanced conditional formatting settings for tasks and messages are primarily managed within the desktop application interface.
Configure and Prioritize Conditional Formatting Rules
Set up the exact conditional rule for completed tasks and arrange the rule hierarchy to prevent other formatting rules from overriding it.
Outlook applies conditional formatting based on the order of the rules in your settings. If a broader rule (like 'read messages') appears higher in the list than your 'completed tasks' rule, the completed tasks will not display the correct color.
Open Outlook, navigate to the View tab in the top ribbon, select View Settings, and then click on Conditional Formatting.
Click the Add button. Name your new rule (for example, 'Completed Messages'), then click the Font button to select your desired color, such as green.
Click the Condition button and navigate to the Advanced tab. Click the Field drop-down, select 'All Task fields', and then choose 'Complete'.
Set the Condition drop-down menu to 'equals' and set the Value to 'Yes'. Click OK to confirm the condition.
Back in the Conditional Formatting window, review the list of rules. Use the Move Up or Move Down buttons to ensure your 'Completed Messages' rule is prioritized correctly above overlapping rules, like those for read or flagged emails.

Remove Conflicting or Duplicate Rules
Delete old or conflicting conditional formatting rules that might interfere with your custom color settings.
Try WPS Office for Your Document and Productivity Needs
While resolving Microsoft Outlook formatting issues, you can enhance your overall productivity with WPS Office. It is a powerful, lightweight, and free alternative for creating and editing documents, spreadsheets, and presentations.

Frequently Asked Questions
Why is my conditional formatting in Outlook not applying to completed messages?
This usually happens due to rule conflicts or incorrect prioritization. If a broader rule, such as formatting for 'read messages', is placed higher in the Conditional Formatting list, it will override the rule set for 'completed messages'.
How can I color-code different types of emails like unread, flagged, and completed?
You can assign different colors by going to View > View Settings > Conditional Formatting. Click 'Add' to create separate rules for each status, define specific conditions under the 'Condition' button, and pick unique colors under the 'Font' button for each rule.
How do I change the priority of my Outlook conditional formatting rules?
Open the Conditional Formatting dialog box via the View Settings menu. Select the rule you want to prioritize and use the 'Move Up' or 'Move Down' buttons on the right side of the window to change its order in the list.




