Excel Online Conditional Formatting: Find or Create a New Rule
Question details
The user wants to create a conditional formatting rule when the New Rule command is not visible 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.
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.
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.
Open the workbook in Excel for the web and select the range you want to format.
Go to Home > Conditional Formatting and choose an available rule type or look for a New Rule or Manage Rules option.
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.
Create the Conditional Formatting Rule in Desktop Excel
Use desktop Excel for rule options that are missing or unavailable in the web app.
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.

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.





