Fix Missing New Rule and Manage Rules Commands in Excel
Question details
The user needs to restore access to the New Rule and Manage Rules commands in Excel’s Conditional Formatting menu.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to create or manage conditional formatting rules in a workbook.
- Observed behavior
- The Conditional Formatting menu shows Clear Rules, but New Rule and Manage Rules are missing.
Open the affected workbook and note which commands appear under Home > Conditional Formatting. Identify whether you are using desktop Excel or Excel for the web, since their menus and troubleshooting options can differ.
Test Conditional Formatting in a New Blank Workbook
Use a blank workbook to determine whether the missing commands are limited to one file.
In Excel, select File > New and open a blank workbook.
Select a cell, then open Home > Conditional Formatting. Look for New Rule and Manage Rules.
Return to the affected workbook and check Home > Conditional Formatting again. If the commands appear only in the blank workbook, investigate the affected file’s settings.
In the affected workbook, open the Review tab and look for Unprotect Sheet. If the sheet is protected, select that command and enter the password if required, then check the menu again.

Repair Microsoft Office on Windows
Try an Office repair if the commands are also missing in a new workbook in desktop Excel on Windows.
Use WPS Spreadsheets for Conditional Formatting
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Open compatible Excel files in WPS Spreadsheets and use its conditional formatting tools without changing your Microsoft Office installation.

Frequently Asked Questions
How can I tell if the problem affects only one workbook?
Open File > New, create a blank workbook, and check Home > Conditional Formatting. If New Rule and Manage Rules appear there but not in the original file, the issue may be specific to that workbook.
Can a protected sheet affect conditional formatting?
Sheet protection can restrict formatting changes. Check the Review tab for Unprotect Sheet and, if authorized, remove protection before checking the Conditional Formatting menu again.
Where can I find my Excel version?
In desktop Excel, open File > Account > About Excel. Include the version information and a screenshot of Home > Conditional Formatting when asking for support.
Does WPS Office repair Excel’s missing commands?
No. WPS Office is an alternative for opening compatible Excel files and working with conditional formatting; it does not repair Microsoft Excel.




