In Microsoft Excel, if a cell comprises a system that outcomes in an error, a triangle seems in the top-left nook of the cell. The triangle is an error indicator. The default is inexperienced however you’ll be able to change to every other that you just like.
How to change the Color of an Error Indicator in Excel
Observe the steps under to change the colour of an error indicator in Microsoft Excel:
- Click on the File tab on the menu bar.
- Click on Choices on the backstage view.
- Excel Choices.
- An Excel Choices dialog field will open.
- Click on the Formulation tab on the left pane.
- Underneath the Error Checking part, click on the checklist field for ‘ Indicate errors using this color’ and select a colour from the checklist.
- Click on Okay.
- The error indicator in the cell turns pink.
Click on the File tab on the menu bar.
Click on Choices on the backstage view.
An Excel Choices dialog field will open.
Click on the Formulation tab on the left pane.
Underneath the Error Checking part, click on the checklist field for ‘ Indicate errors using this color’ and select a colour from the checklist.
Click on Okay.
The error indicator in the cell turns pink.
Learn: How to use Objective Search in Excel?
How do you establish errors?
In Microsoft Excel, you shouldn’t have to establish an error; Excel will try this for you. You will notice an error pop up in your cell with a inexperienced triangle at the prime left of the cell. In Microsoft Excel, a handful of errors can seem in your cells, akin to Ref, null, Num, Worth, and so on.
Why do spreadsheets have errors?
Like most applications, errors could be triggered in Microsoft Phrase. Errors can happen in Excel due to customers typing the flawed system references, by accident deleting an essential cell or row in the spreadsheet, and extra.
We hope this tutorial helps you perceive how to change the colour of an error indicator in Excel; when you’ve got questions on the tutorial, tell us in the feedback.
