Setting Up Conditional Formatting in Microsoft Lists

Microsoft Lists is a powerful tool for organizing, tracking, and managing information. But beyond just storing data, Lists also lets you visually highlight important details using conditional formatting — a feature that can make your lists more intuitive and actionable at a glance.

In this post, we’ll walk through what conditional formatting is, why it’s useful, and how you can set it up step by step.

What Is Conditional Formatting?

Conditional formatting allows you to automatically change how list items look — such as their color, font, or background — based on the values in specific columns.

For example:

Highlight overdue tasks in red
Mark completed items in green
Shade high-priority items in yellow
Add icons or status bars to visually represent progress

This kind of visual cue helps users quickly understand what’s important without reading every entry.

Why Use Conditional Formatting?

Conditional formatting helps:

Improve readability – instantly see what needs attention
Enhance productivity – prioritize tasks without manual filtering
Support decision-making – visualize status, performance, or deadlines

How to Set Up Conditional Formatting in Microsoft Lists

Step 1: Open Your List

Go to your Microsoft List within SharePoint or the Lists app in Microsoft 365. Choose the list you want to format.

Step 2: Switch to Format Mode

Click the column header you want to format.
Select Column settings → Format this column.

This opens the formatting pane on the right-hand side.

Step 3: Choose “Conditional Formatting”

In the formatting pane:

Select Conditional formatting.
Click + Add rule to create your first condition.

Step 4: Define Your Condition

You can set rules based on:

Text values (e.g., “equals”, “contains”, “begins with”)
Number ranges (e.g., “greater than”, “less than”)
Dates (e.g., “before”, “after”, “is today”)

Example:

If Status equals Completed, then set the background color to green.

You can create multiple rules for a single column.

Step 5: Apply Formatting

Choose the color, font style, or icon to apply when the condition is met.
Options include:

Text color
Background color
Bold/italic font
Data bar
Icons (for visual indicators)

Step 6: Save and View

Once done, click Save.
Your list items will now visually reflect the rules you’ve created!

Pro Tip: Use JSON for Advanced Formatting

If you want even more control (for example, to format entire rows or use complex logic), you can switch to “Advanced mode” and apply custom JSON formatting.

Microsoft provides templates you can copy and modify directly from the official JSON formatting documentation.

🪄 Example Use Cases

Scenario	Rule	Visual Result
Task Management	Status = “Overdue”	Red background
Issue Tracking	Priority = “High”	Orange highlight
Sales Pipeline	Deal Value > $50,000	Bold text with 💰 icon
Event Planning	Date = Today	Blue border

Conditional formatting transforms your Microsoft Lists from plain data into a dynamic, visual dashboard. Whether you’re tracking projects, managing tasks, or organizing events, it ensures that important details pop out immediately — helping teams stay informed and responsive.