Blank Cell - Color code and formatting This feature is mostly used to identify blank cells and if any time some one has accidentally deleted any value in the cell which can be identified with this trick. How to do this – Step 1 - Please click on new rule (conditional formatting) under Home tab Step 2 - Select rule type as “Format only cells that contains” Step 3 - Under edit rule section choose blanks from the drop down and click on format and select fill with color of your choice, then click on OK , again click on OK
Blank Cell – selection and fill with required data from above cells This feature is mostly used, for to select the blank cells in the excel. How to do this – Step 1 - Please click on GoTo or press F5 under Home tab, then click on special will open a new dialogue box Step 2 - Choose the radio button Blanks Step 3: Click on OK You can also press F5 in keyboard to get Goto Menu. Once blank cells are selected use formula, press = (is equal to) and selected the upper cell and press Ctrl + Enter. So that blank cells are filled with required data.