asayyappan
New Member
I m using excel sheet where data is to be filled by other people.
Column A to M
if A2 is filed with data then it should check B2:M2
and if any blank cells then display message and highlight on the blank cell
if A2 is blank then no message, no highlight
A B C D E F G H I J K L M
Employee Code No. Employee Name Gender Employement Status Date Of Birth Date Of Joining Location Region Vertical Department Grade Designation Type of Employee
Kindly help me
Column A to M
if A2 is filed with data then it should check B2:M2
and if any blank cells then display message and highlight on the blank cell
if A2 is blank then no message, no highlight
A B C D E F G H I J K L M
Employee Code No. Employee Name Gender Employement Status Date Of Birth Date Of Joining Location Region Vertical Department Grade Designation Type of Employee
Kindly help me