How to Get Rid of Green Highlight in Excel

To get rid of green highlighting in Excel, first identify what it marks: click another cell to move the active-cell border, use Home > Fill Color > No Fill to remove a green fill, or clear the conditional-formatting rule that applies it. A green table style or small green error triangle needs a different fix, so check the shape and location before changing anything.

What You’ll Need

The workbook open in Excel for Microsoft 365 on Windows. Save a copy first if you plan to remove formatting from many cells or change a whole worksheet.
Permission to edit the workbook. If the sheet is protected, you may need its password or help from the workbook owner.
A moment to identify the mark: note whether it is a thin outline, a solid cell background, a table-wide style, a cross-shaped row-and-column highlight, or a small triangle in a cell corner.

Step-by-Step

Identify which kind of green mark you have. A thin green outline around one cell usually marks the active cell. A solid green background fills the cell. Green shading repeated across a formatted list may come from a table style or conditional formatting. A small green triangle in the upper-left corner is an error indicator, not a fill. If a row and column are shaded around the selected cell, look for the Focus Cell feature. Correctly identifying the mark prevents you from clearing unrelated formatting.
Move the active-cell outline if it is only around one cell. Click another cell in the worksheet. The green border moves to the new active cell; it does not disappear while Excel is ready for input because Excel uses it to show where typing will go. If you are editing a formula and colored outlines have appeared around referenced cells, press Esc to cancel the edit or Enter to finish it. The reference outlines should then go away. If your goal is to make the border invisible, Excel does not provide a normal setting to hide the active-cell indicator while you work.
Remove a manually applied green cell fill. Select the affected cell or range. On the Home tab, open the arrow beside Fill Color in the Font group, then choose No Fill. This removes the cell background color without deleting its contents. If the green remains, it may be supplied by conditional formatting or a table style rather than a manually selected fill. You can check a single cell by opening the Fill Color menu: a selected color can indicate a direct fill, but other formatting rules may still override what you see.
Clear a conditional-formatting highlight from only the cells you selected. Select the green cells, then choose Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells. This removes conditional-formatting rules affecting that selection. It does not erase values or formulas, but it may remove other conditional formatting from those cells too, such as color scales, data bars, or warning colors. If those other visual cues matter, use the rule manager in the next step instead of clearing every rule.
Inspect or edit the rule if the highlight should remain in some cases. Select a cell that turns green, then choose Home > Conditional Formatting > Manage Rules. In the Show formatting rules for menu, choose Current Selection or This Worksheet so you can locate the relevant rule. Select the rule and choose Edit Rule to change its condition or format, or Delete Rule to remove it. If you choose This Worksheet, check the Applies to range before deleting: a rule may cover more cells than the one you initially selected. Select OK or Apply to keep your changes.
Change a green table style without converting the table to a range. Click inside the table so the Table Design tab appears. In Table Styles, choose a different style, or use the More button to view additional styles. To remove the colored appearance, choose a plain or light style; to keep helpful table features while reducing green, turn options such as Banded Rows off in Table Design. A table style applies to the table as a whole, so changing one cell’s fill may not remove the style consistently. Avoid Convert to Range unless you really want to stop using table features such as automatic expansion and structured references.
Turn off the row-and-column cross highlight if it is enabled. If the selected cell is surrounded by shaded row and column guides, open the View tab and click Focus Cell to turn it off. This feature is available in some current Microsoft 365 versions; if you do not see Focus Cell, the highlight may instead be a cell fill, table style, or add-in feature. On Excel for the web, check the View tab for the same control if it is available in your build.
Handle a small green corner triangle separately. Click the cell and select the warning button that appears beside it to review the message. Correct the underlying issue if appropriate—for example, a number stored as text—or choose Ignore Error if the value is intentional. To turn off background error indicators in desktop Excel for Windows, go to File > Options > Formulas and clear Enable background error checking. This affects error indicators in the workbook, not green fills or active-cell borders. On Mac, look under Excel > Preferences or Excel > Settings for Error Checking; labels can vary by release.

Common Mistakes

Clearing the fill when a rule is responsible. No Fill removes a direct background color, but conditional formatting can immediately display green again. If that happens, inspect Conditional Formatting > Manage Rules rather than repeatedly applying No Fill.

Clearing every rule on the worksheet. Clear Rules from Entire Sheet is a broad action. It can remove useful alerts, duplicate-value markings, and other formats far beyond the cell you meant to fix. Start with the selected cells, or edit one specific rule after checking its Applies to range.

Trying to remove the active-cell border with a formatting command. The border is Excel’s input indicator, not a fill or a conditional format. Clicking another cell moves it; deleting formatting will not make the indicator disappear. It is also not normally printed as cell formatting.

Changing a table cell instead of its table style. If the green appears in alternating rows or across the whole table, it is probably a style. Change the style from Table Design rather than applying a different fill to each cell, which can create inconsistent formatting.

Ignoring what a green triangle says. A triangle is an error-checking prompt, not decoration. Read the warning before ignoring it; a number stored as text may cause sorting or calculations to behave differently from what you expect.

Tips

Test the fix on one cell or a small range first. If the result is right, extend the selection to the rest of the affected cells.
Before a large formatting cleanup, save a new copy of the workbook. Excel’s Undo button can reverse many formatting changes, but saving a copy gives you a fallback if you close the file or make several changes afterward.
Use the Format Painter only when you intentionally want to copy another cell’s formatting. It can copy a fill, borders, and number formats together, not just remove green.
If you need to locate affected cells, use Home > Find & Select > Find to search for a known value or label, then inspect the matching cells. Finding cells by color is not available in every Excel version or search setup, so do not rely on it as the only way to identify a rule.
Excel for Mac has similar Home and Conditional Formatting controls, although tabs and dialog layouts can differ. In Excel for the web, formatting controls are available in the ribbon, but some desktop settings—especially background error-checking options—may require opening the workbook in the desktop app.
If the workbook is shared, ask whether the green format is intentional before deleting a rule that affects other people’s work. A conditional-formatting color may be communicating status or an exception.

Troubleshooting

The green comes back after I choose No Fill. A conditional-formatting rule or table style is probably applying it. Check whether the cell is inside a table, then inspect Home > Conditional Formatting > Manage Rules. If the rule is correct but the cell should be excluded, edit the rule’s Applies to range or condition rather than repeatedly removing the visible fill.

I cannot select or format the green cells. The worksheet may be protected, or the workbook may be open in a restricted mode. Check Review > Unprotect Sheet; Excel may ask for a password. If you do not have it, contact the owner instead of trying to work around the protection. In a shared or read-only workbook, request edit access or save an editable copy if your organization permits it.

The whole table is still green after I changed one cell. Click inside it and choose a different Table Style from Table Design. If the table style is not the cause, select a green cell and check whether conditional formatting applies to the table range. Table styles and conditional formatting can coexist, so changing one may leave the other visible.

The triangle is gone, but I still see green shading. Disabling background error checking only removes the corner indicator. Use No Fill, review conditional formatting, or change the table style depending on the remaining mark. These are separate Excel features.

The active-cell border will not disappear. That is expected: the active cell must remain visible so you know where input will go. Click another cell to move it, or select a different worksheet. If you are viewing a cross-shaped highlight rather than a border, check View > Focus Cell instead.

The commands are unavailable or the change does not stick. Verify that you have selected cells rather than an object such as a chart, and check for sheet protection. If you are in Excel for the web, try opening the file in desktop Excel for settings that are missing from the browser. If another user or an add-in reapplies formatting, review the workbook’s sharing or automation setup.

Frequently Asked Questions

Can I permanently remove the green outline around the active cell?
Excel normally keeps a visible outline around the active cell. You can move it by clicking elsewhere, but there is no standard workbook setting to hide it while editing.

Will removing green highlighting delete my data?
No. No Fill and formatting-rule changes affect appearance, not cell values. Still, review the selected range before clearing rules, because a rule may apply to more cells than expected.

Why does green highlighting appear only when a value meets a condition?
That pattern usually indicates conditional formatting. Open Home > Conditional Formatting > Manage Rules, find the condition, and edit or delete it as needed.

Why are only alternating rows green?
The range may be an Excel table with banded rows enabled. Click in the table and choose another style in Table Design, or turn off Banded Rows if you want to retain the existing style without alternating shading.

Does green cell formatting print?
A cell’s fill color, table style, and conditional formatting can print. The active-cell outline and the green error-indicator triangle are screen cues and are not normally printed as cell formatting.

Can I remove green highlighting in Excel for the web?
Yes, for common fills, table styles, and conditional formatting, use the corresponding Home or Table controls in the browser ribbon. Some advanced settings, including background error checking, may require the desktop version.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.