What Excel's Red and Green Triangle Indicators Mean GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office 49 49 people found this article helpful
What Excel's Red and Green Triangle Indicators Mean
Understand and change default options for these indicators
By Ted French Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. lifewire's editorial guidelines Updated on April 20, 2020 Tweet Share Email Tweet Share Email In This Article
Expand Jump to a Section What is the Green Triangle? Turn off the Green Triangle Change the Error Checking Rules Change the Color of an Error-Indicating Triangle What is the Red Triangle? In Microsoft Excel, green triangles indicate possible errors in a cell's contents. Red triangles indicate the presence of user comments in the worksheet cell. The green triangle appears in the top left corner of a cell, while the red triangle appears in the top right corner of a cell. Here's a look at how these indicators function and how to change their default settings. Instructions in this article apply to Excel 2019, Excel 2016, Excel 2013, Excel 2010, and Excel for Microsoft 365. The Green Triangle
The green triangle appears in a cell when the cell's contents violate one of Excel's error-checking rules. These rules are turned on by default and monitor for common mistakes such as cells containing formulas that result in an error, including #VALUE! or #DIV/0!; formulas that are inconsistent or different from formulas in surrounding cells; and numbers formatted as text data. When you select a cell with a green triangle, the Error Options button appears next to it. The Error Options button is a yellow diamond with a gray square background. It offers options for correcting the perceived error. Turn off the Green Triangle
Error checking is turned on by default in Excel, so the green triangles appear in cells that contain a rule violation. If you don't want to see these indicators, change this default setting and turn off error checking in the Excel Options dialog box. Go to File and select Options to open the Excel Options dialog box. Select the Formulas tab. In the Error Checking section, clear the Enable background error checking checkbox. Select OK to accept the change and close the Excel Options dialog box. You've now turned off the green triangle indicators. Changing the Error Checking Rules
Make changes to error-checking rules in the Excel Options dialog box. Go to File and select Options. Select the Formulas tab. In the Error checking rules section, select the checkboxes for the options you want to enable, or clear the checkboxes for the options you want to disable. Select OK to apply the changes. You've set your new error-checking rules. Change the Color of an Error-Indicating Triangle
If you prefer, change the green default color of the error-indicating triangle in the Excel Options dialog box. To change the green triangle to a different color: Go to File and select Options. Select the Formulas tab. Select the Indicate errors using this color dropdown arrow and choose a different color from the color palette. Select OK to accept the change and close the Excel Options dialog box. You've changed the color of the error-indicating triangles. Red Triangle in Excel Cell
A red triangle in the top right corner of a cell indicates that someone added a comment to the cell. To read the comment, hover over the cell containing the red triangle. A text box containing the comment appears next to the cell. In Excel 2019, a red triangle indicates a Note. A purple indicator in the corner indicates a Threaded Comment that is used to reply to an original comment and to add further comments. There are some comment options. Opt not to display comments or indicators, even when hovering over a cell containing a comment. Or, opt always to display comments and indicators for all cells containing comments. To change the comment options: Go to File and select Options. Select the Advanced tab. Scroll to the Display section. Under For cells with comments show, choose to show No comments or indicators, Indicators only and comments on hover, or Comments and indicators. Select OK to accept the changes and close the Excel Options dialog box. Excel options for creating, editing, moving, or deleting cell comments are located under the Review tab in the Comments section of the ribbon. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Combine the ROUND and SUM Functions in Excel How to Use the Excel MID Function How to Change the Number of Decimal Places in Excel How to Use the DAY function in Excel Use Excel's EOMONTH Function to Add or Subtract Months How to Use the Round Function in Excel How to Use the COUNTIF Function in Excel How to Use a Dynamic Range in Excel With COUNTIF and INDIRECT How to Calculate Percentage in Excel How to Enable or Disable AutoComplete in MS Word Using Formulas for Conditional Formatting in Excel Shade Alternate Rows With Excel Conditional Formatting #NULL!, #REF!, #DIV/0!, and ##### Errors in Excel How to Sort Data in Excel How to Add Numbers in Excel Using a Formula The 12 Best Tips for Using Excel for Android in 2022 Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies