Formatting Issues

Fix Missing New Rule and Manage Rules Commands in Excel

Bushra ParveenBushra Parveen Nov 14, 2026 869 views

Question details

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

Fix Missing Conditional Formatting Rule Commands in Excel
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.
Before you start

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.

Solution 1Recommended

Test Conditional Formatting in a New Blank Workbook

Use a blank workbook to determine whether the missing commands are limited to one file.

1
Create a blank workbook

In Excel, select File > New and open a blank workbook.

2
Check the menu

Select a cell, then open Home > Conditional Formatting. Look for New Rule and Manage Rules.

3
Compare the workbooks

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.

4
Check sheet protection

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.

Test Conditional Formatting in a New Blank Workbook
If the commands are still missing: Record your Excel version and take a screenshot of the Conditional Formatting menu. In desktop Excel, version information is typically available under File > Account > About Excel.
Free Microsoft Office alternative

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.

Apply conditional formatting to highlight spreadsheet dataCompatible with Microsoft Excel formats, including XLSXFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

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.