Macro to Highlight Blank Cells in Excel | VBA Code to Highlight Blank Cells in Excel
Open Excel Sheet
Press Alt + F11 Key
Go to the Insert Menu and Click on new Module
in New Module copy and paste the above VBA code and save.
Now Press Alt + F8 and new windows will open which is shown in below figure,
in that windows you will ask to enter a key to create a shortcut for Paste Special
Enter a letter in the box.
Macro to Highlight Blank Cells in Excel | VBA Code to Highlight Blank Cells in Excel
Sub HighlightBlankCells()
Dim Dataset as Range
Set Dataset = Selection
Dataset.SpecialCells(xlCellTypeBlanks).Interior.Color = vbRed
End Sub