How to Highlight Cells that are Errors

Using conditional formatting, you can quickly highlight all the cells that are errors. Please follow the steps below, or check here to highlight cells that are not errors.

Step 1: Select the data range;

Step 2: Click the "Home" tab from the Ribbon;

Step 3: Click the "Conditional Formatting" command in the "Styles" section;

Step 4: Click the "Highlight Cells Rules" command from the drop-down list, then select "More rules" from the extended list;

Step 5: In the "New Formatting Rule" window, select "Errors" in the first box;

Step 6: Click the "Format" button and select the formatting style in the "Format Cells" window, e.g., fill the cells with blue;

Step 7: Click "OK" at the bottom and you will see cells with errors are now in blue.

Leave a Reply