Blank Cell - Color code and formatting

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 chooseblanks from the drop down and click on format and select fill with color of your choice, then click on OK, again click on OK