lkpprotect.blogg.se

Here, from the very first box of drop-down, select Blanks as cell value. And below, in Edit the Rule Description box, we have different criteria to define.But for Blank cell, select the second option, which is Format only cells that contain. There we have a different rule to apply conditional formatting. A window of the New Formatting Rule will open up.Once we do that, we will get the drop-down list of Conditional Formatting.For that, go to the Home menu and select Conditional Formatting under the Styles section, as shown below. We will apply the conditional formatting in a defined region only.For this, we have selected a small portion of the sheet covered with a thick border, as shown below. If we apply the conditional formatting to complete a blank sheet or some cells of it, we will see how the cell gets highlighted. This is the best way to see and apply conditional formatting for a blank sheet or some of the cells of a blank sheet. We will be covering the small portion of Conditional Formatting, which Highlights the Blank Cells. You can download this Conditional Formatting For Blank Cells Excel Template here – Conditional Formatting For Blank Cells Excel Template Example #1