From this, we can highlight the duplicate, color the cell as per different value range, etc.

This is the best way to see and apply conditional formatting for a blank sheet or some of the cells of a blank sheet.

If we apply the conditional formatting to complete blank sheet or some cells of it then we will be able to see how the cell gets highlighted.

For this, we have selected a small portion of the sheet covered with a thick border as shown below.

For that go to the Home menu and select Conditional Formatting under Styles section as shown below.

There we have a different rule to apply conditional formatting.

But for Blank cell, select the second option which is Format only cells that contain.

Here, from the very first box of drop down select Blanks as cell value.

For highlighting blank cells go to Fill tab and select any desired color as per requirement.

As we can see, the cells with any value are now changed to No Fill cell as shown below.

But here we have to select the last option which is Use a formula to determine which cells to format.

Once done. Click on OK to apply.

For testing, we have deleted some cells data and the color of those cells change from No Fill to Red Peach.

Which shows our selected and applied conditions are working properly.

By this, we can highlight the cell and attributes which are left blank.

Once we select, it will always check and look for the preview before applying the changes.

Show Blanks To Zero Excel How To Apply Conditional

Here we discuss how to apply Conditional formatting for blank cells along with practical examples and downloadable excel template.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

Show Blanks To Zero Excel For Mac