Excel Guides

Conditional Formats that Distinguish Blanks and Zeroes in Excel

When working with data in Excel, you may want to apply conditional formatting to blank cells or cells that contain zeroes. This can be helpful in identifying errors or ensuring that data is entered correctly.

To format blank cells, select the cells you want to format and then click the Home tab. In the Styles group, click Conditional Formatting and then click New Rule.

In the New Formatting Rule dialog box, select Format only cells that contain in the first drop-down list.

In the second drop-down list, select Blanks and then click the Format button.

In the Format Cells dialog box, select the fill color or pattern you want to use for blank cells and then click OK.

To format cells that contain zeroes, select the cells you want to format and then click the Home tab. In the Styles group, click Conditional Formatting and then click New Rule.

In the New Formatting Rule dialog box, select Format only cells that contain in the first drop-down list.

In the second drop-down list, select Cell Value and then enter =0 in the third field. Click the Format button.

In the Format Cells dialog box, select the fill color or pattern you want to use for cells that contain zeroes and then click OK.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.