How do i show our warning signs when Excel cells are empty to prevent missing data

When you use Excel to edit data, some cells must be filled out, so in order to prevent leakage, or forget to fill in the situation. We usually set a warning flag for these cells, and in general we fill them with color to remind us. So how do we display our warning flags when Excel cells are empty? The following small series for everyone to introduce, a look at it!

Set up the process

The first step is to open the Excel table that we want to make the settings change.

In the second step, we can see that each cell in the Open table is part of the list that must be filled out, otherwise it would be a hassle to get the money wrong or hit someone else's account. The small series is to select all the cells that must be filled out.

Third step after we select the cell, we click on the small triangle in the conditional format to exhale the Drop-down menu, and then we click the new rule in the conditional Format menu.

The fourth step is to select "format only the cells that contain the following" in the menu under the new rule.

The fifth step is to select "Null values", as shown in the following figure, when you have selected "format only cells that contain the following".

The sixth step is to go to the menu shown in the following image to select the Format button.

Step seventh we're on the way. To format a cell we select the Fill button directly.

The eighth step we can set the color of the fill, where the small series is set to green because the green comfortable well, hehe .... Of course, you are free to set the ha. then click OK.

In the Nineth step we can see that Excel will give us a bounce back to the new formatting rules we click OK directly.

Then we can see our table becomes like this, we can find that when he is all empty value is green, here a small number of data to go in to show you the effect.

Then we can see the effect, I believe that we will never be tired of leaking data, or forget to fill out. It's not going to cause you any unnecessary trouble.

The above is the Excel cell is empty when how to show our warning signs to prevent the data from leaking method introduction, we learned? Just follow the steps above!