Formatting Issues

How to Fix Excel Cells Highlighted Light Blue

Nimra Malik Oct 12, 2026 870 views

Question details

The user wants to know why certain Excel cells are highlighted light blue and how to remove or modify this formatting.

Why Are Some Excel Cells Highlighted Light Blue and How to Fix It

Product: Excel
Device & OS: not provided
Scenario: Working on an Excel worksheet where specific cells appear with an unexpected light blue highlight.
Observed behavior: Certain cells in the worksheet are highlighted light blue, which is usually caused by tables, cell styles, or conditional formatting rules rather than selection issues.

Before you start

Before making changes, select the affected cells to observe if the light blue color is static or if it only appears when specific data is entered, which helps determine if it's conditional formatting.

Solution 1Recommended

Check and Clear Conditional Formatting Rules

Conditional formatting automatically applies colors based on cell values. Clearing these rules can instantly remove unexpected blue highlights.

Often, a rule is set up to highlight duplicate values, specific text, or numbers above a certain threshold with a light blue fill.

Select the affected cells

Click and drag to highlight the cells that are displaying the unwanted light blue background.

Open Conditional Formatting

Navigate to the 'Home' tab on the Excel ribbon and click on 'Conditional Formatting' in the Styles group.

Clear the rules

Hover over 'Clear Rules' from the dropdown menu, then select 'Clear Rules from Selected Cells'. If the entire sheet is affected, you can choose 'Clear Rules from Entire Sheet'.

Check and Clear Conditional Formatting Rules

Quick Check: If you don't want to delete the rule entirely, click 'Manage Rules' instead to edit the fill color or adjust the condition.

Solution 2

Remove Cell Fill and Reset Cell Styles

The cells might have a static light blue fill applied manually or through a predefined Excel cell style.

Solution 3

Remove Excel Table Formatting

If the blue cells are part of a striped Excel table design, converting it back to a normal range will allow you to clear the format easily.

Clear Cell Formatting Easily

Easily Manage and Clear Cell Formatting in WPS Spreadsheet

WPS Spreadsheet provides intuitive tools to quickly identify, modify, and clear conditional formatting, tables, and cell styles, ensuring your data presentation remains clean and professional.

1. Open the workbook: Open your formatted workbook in WPS Spreadsheet and select the light blue cells.
2. Locate the clear tool: Navigate to the 'Home' tab on the top ribbon.
3. Clear formats: Click on the 'Clear' tool (eraser icon) and select 'Clear Formats' to instantly remove all styling, including the blue highlight.
4. Manage conditional rules: Alternatively, use the 'Conditional Formatting' menu on the Home tab to pinpoint and delete specific dynamic background rules.

Quickly clear or modify conditional formatting rules with a few intuitive clicks.Seamlessly compatible with Microsoft Excel (.xlsx) formatting, tables, and styles.Lightweight software with a familiar, user-friendly interface for effortless data management.

microsoft office alternative - wps office

Frequently Asked Questions

Why does a cell turn blue only when I type a specific word?

This happens because a conditional formatting rule is set to change the cell's background color when it contains specific text. You can manage or disable this in Home > Conditional Formatting > Manage Rules.

How do I remove the alternating light blue rows in my spreadsheet?

Alternating blue rows are usually part of a Table style. Click inside the data, go to the 'Table Design' tab, and uncheck 'Banded Rows', or choose a plain table style from the gallery.

Will removing the blue formatting delete my formulas or data?

No, clearing conditional formatting rules or changing cell styles only affects the visual appearance (like background color and font style) and will not alter or delete the actual data or formulas in your cells.

Document & File Issues