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.
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.
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.
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.
Step5: checked Stop If True check box for your newly created rule. And click on Ok button.
Step6: you would notice that conditional formatting have been removed on the all blank cells in the selected range of cells.
Comments
So empty here ... leave a comment!