Office Apps Freezing

How to Fix Excel Conditional Formatting Menu Not Loading

Aamir Naveed Akram Oct 9, 2026 868 views

Question details

The user cannot access or use the Conditional Formatting menu in Excel because it gets stuck on a continuous loading state.

How to Fix Excel Conditional Formatting Menu Not Loading

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating or editing conditional formatting rules in an Excel spreadsheet.
Observed behavior: The Conditional Formatting dropdown displays repeated loading messages instead of showing the available formatting options, preventing any rule configuration.

Before you start

Ensure you have saved all your open workbooks and completely close out of any active Excel background processes using the Task Manager before beginning the troubleshooting steps.

Solution 1Recommended

Start Excel in Safe Mode and Disable Add-ins

Running Excel in Safe Mode bypasses background processes and add-ins that frequently cause the formatting menus to freeze or continuously load.

Third-party COM add-ins often conflict with Excel's core features. By launching the application in Safe Mode, you can determine if a specific plugin is causing the Conditional Formatting menu to fail.

Launch Safe Mode

Press the Windows Key + R to open the Run dialog box. Type 'excel /safe' and press Enter to launch Excel in Safe Mode.

Test Conditional Formatting

Open a new or existing workbook and click on the Conditional Formatting menu in the Home tab. If it loads normally, an add-in is likely the culprit.

Access Add-in Settings

Go to File > Options > Add-ins. At the bottom of the window, select 'COM Add-ins' from the Manage dropdown menu and click 'Go...'.

Disable Add-ins

Uncheck all the boxes in the list to disable your add-ins, click OK, and restart Excel normally to see if the problem is resolved.

Identify the Culprit: If disabling all add-ins fixes the menu, enable them one by one and restart Excel each time to pinpoint exactly which add-in is causing the loading issue.

Solution 2

Update and Repair the Microsoft Office Installation

Outdated software versions or corrupted installation files can cause Excel's user interface elements to stop functioning correctly.

Seamless Excel Alternative

Use WPS Spreadsheets for Fast, Freeze-Free Conditional Formatting

Avoid endless loading screens and app crashes. WPS Spreadsheets is a lightweight, fully compatible tool that allows you to open your existing Excel workbooks and apply complex conditional formatting rules instantly without any hassle.

1. Install WPS Office: Download and install the free WPS Office suite on your computer.
2. Open Your Workbook: Launch WPS Spreadsheets and open your existing .xlsx Excel file.
3. Select the Data: Highlight the range of cells where you want to apply formatting rules.
4. Access Conditional Formatting: Navigate to the Home tab on the top ribbon and click on 'Conditional Formatting'.
5. Apply Rules Instantly: Choose your desired formatting rules, such as Highlight Cell Rules or Data Bars, and apply them smoothly without loading delays.

Free and lightweight with no heavy background processes to slow you downFully compatible with Microsoft Excel (.xlsx) formats and existing formulasSmooth and responsive Conditional Formatting menu with familiar optionsFamiliar ribbon interface requires no learning curve to master

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel Conditional Formatting menu get stuck on a loading message?

This usually happens due to conflicting third-party COM add-ins, corrupted Office installation files, pending software updates, or a corrupted specific workbook that interferes with the application's user interface.

Will reinstalling Microsoft Office delete my Excel files?

No, uninstalling and reinstalling Microsoft Office only removes the application files. Your personal workbooks and documents saved on your local hard drive or OneDrive will remain completely intact and safe.

How can I remove conditional formatting rules if the menu won't open?

If the Conditional Formatting menu is entirely inaccessible, you can clear formats by selecting the affected cells, going to the Home tab, clicking 'Clear' (the eraser icon) in the Editing group, and selecting 'Clear Formats'. Note that this will remove all cell formatting like borders and colors, not just the conditional rules.

Does running Excel in Safe Mode fix the problem permanently?

No, Safe Mode is a diagnostic tool that temporarily disables add-ins and custom settings to help you troubleshoot. If Excel works perfectly in Safe Mode, you must manually identify and permanently disable the problematic add-in to fix the issue in normal mode.

Office App Problems