How to Remove Conditional Formatting on Blank Cells in Excel

This post will guide you how to remove conditional formatting if cell is blank in Excel. How do I skip conditional formatting for blank cells in Excel 2013/2016.

Remove Conditional Formatting on Blank Cells


Assuming that you have a list of data in range B1:B5, in which contain text values and blank cells, and have been highlighted with green color using Conditional Formatting . And you wish to remove conditional formatting for all blank cells in your worksheet. How to accomplish it. You just need to do the following steps:

Step1: select your range of cells that have been highlighted with red color using Conditional Formatting.

remove conditial formatting on blank cell1

Step2: go to Home tab, click Conditional Formatting command under Styles group. And select New Rule from the context menu list. And the New Formatting Rule dialog will appear.

remove conditial formatting on blank cell2

Step3: select Use a formula to determine which cells to format under Select a Rule Type list box in the New Formatting Rule dialog box, and type the following formula into Format values where this formula is true text box, and keep the Format as No Format Set. Click Ok button.

remove conditial formatting on blank cell3

Step4: go to Home tab, click Conditional Formatting command under Styles group. And select Manage Rules from the context menu list. And the Conditional Formatting Rules Manager dialog will appear.

remove conditial formatting on blank cell4

Step5: checked Stop If True check box for your newly created rule. And click on Ok button.

remove conditial formatting on blank cell5

Step6: you would notice that conditional formatting have been removed on the all blank cells in the selected range of cells.

remove conditial formatting on blank cell6

 

 

You might also like:

Sidebar