TEACHING EXCEL FOR DATA ANALYSIS: HANDS ON 28 Customizing formula options

 

Customizing formula options

You have found that the default color that is used to identify formula errors is too hard to see. You need to change this color by modifying some of the settings in the Formulas category of the Excel Options dialog box.

1. To begin, open a blank workbook in Microsoft 365 Excel:

2. In the newly opened workbook, click cell B2 and type “=100*J” and then press Enter:

3. Note the green triangle in the top left corner of the cell:

4. Next, click File → Options:

5. The Excel Options dialog box will open to the General category:

6. Click the Formulas category:

7. With the Formulas category now open, examine the Error Checking section. Here, you will see that the default error indicator color is a shade of green:

8. Click the Indicate errors using this color drop-down command and click Red:

9. With the new error indicator color now selected, click OK to apply this new setting:

10. Note that the error indicator in cell B2 is now red:

11. Close Microsoft 365 Excel to complete this activity.