Highlight blank cell in a selected range of a sheet

i AM GLAD TO ANNOUNCE THAT MY FIRST QUES WAS ANS WITH IN TWO DAYS BY EXCEL FORUM

SO COMING AGAIN WITH HOPES


CAN SOMEBODY HELP PLZ PROVIDE ME A MACRO OR VBA THAT CAN HIGHLIGHT ALL THE BLANK CELLS IN A SPECIFIED RANGE WITH YELLOW COLOR LETS SAY COLUMN B7 TO H51000

AFTER HIGHLIGHTING THE BLANK CELL THE CODE GIVES A MSG TOO"PLEASE FILL ALL THE HIGHLIGHTED YELLOW CELLS"

LETS SAY B7 IS FILLED BUT B8 IS NOT SO IT CAN HIGHLIGHT B8 AND LIKE WISE AHEAD

AND SHOW A MSG "DATA COMPLETE YOU MAY PROCEED" IF ALL THE CELLS ARE FILLED