Formatting Issues

Excel Online Conditional Formatting: Find or Create a New Rule

John WilsonJohn Wilson Nov 20, 2026 868 views

Question details

The user wants to create a conditional formatting rule when the New Rule command is not visible in Excel Online.

How to Create a Conditional Formatting Rule When New Rule Is Missing in Excel Online
Product
Microsoft Excel Online
Device & OS
not provided
Scenario
The user is editing a workbook in a browser and wants to apply a new conditional formatting rule.
Observed behavior
The desktop Excel New Rule command is not visible in Excel Online; existing supported rules can still be displayed.
Before you start

Check that you have editing permission for the workbook and select the cells you want to format. Excel for the web features and menus may vary, so look for both preset rules and rule management options under Home > Conditional Formatting.

Solution 1

Check Conditional Formatting Options in Excel for the Web

Use the web app when it offers a rule type that meets your needs.

Excel for the web supports creating and managing conditional formatting rules, although the available options and their labels may differ from desktop Excel.

1
Select the cells

Open the workbook in Excel for the web and select the range you want to format.

2
Choose a rule

Go to Home > Conditional Formatting and choose an available rule type or look for a New Rule or Manage Rules option.

3
Set the formatting

Enter the condition and choose a format, then select the button to apply or save the rule. If the required rule type is unavailable, use desktop Excel instead.

Free Microsoft Office alternative

Work With Spreadsheet Formatting in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Open Excel files in WPS Spreadsheets and use its conditional formatting tools, making it easier to move everyday spreadsheet work between Office applications.

Apply conditional formatting to highlight spreadsheet dataCompatible with Microsoft Excel XLS and XLSX filesFamiliar spreadsheet interface for an easier transitionFree and lightweight for everyday office work
microsoft office alternative - wps office

Frequently Asked Questions

Can I create conditional formatting rules in Excel Online?

Yes. Select a range and open Home > Conditional Formatting to see the rule types available in Excel for the web. Some options may differ from desktop Excel.

What if the rule type I need is missing from Excel for the web?

Open the workbook in desktop Excel, select the cells, and choose Home > Conditional Formatting > New Rule. Save the file to OneDrive or SharePoint before reopening it in the browser.

Will a desktop Excel rule appear in the browser?

Supported conditional formatting rules can appear when you reopen the saved workbook in Excel for the web. Check the cells because some features may behave differently in the browser.

Why can't I change formatting in my online workbook?

The workbook may be open in view-only mode or you may lack editing permission. Check the editing controls in Excel for the web or ask the file owner for permission.