If you are just wanting to find the empty cell(s) and highlight it (them), then this simple macro should do the job for you:-
Selection.Interior.ColorIndex = 8
You can change the colour index to suit yourself.
Alternatively, you can just use the in-built Excel find function:
Home tab--->Editing--->Find & Select. In the menu that appears, select Go To Special. In the Go To Special dialogue box that appears, select blanks then OK.
Hopefully, this is what you were after.