Cell data can not be validated for empty (blank) cells. Blank cells are simply ignored that way. The only way to do this validation is through macro.