Having the drop down option include "Completed", "In Progress",etc... in one
column of the sheet name called "Task Sheet". i want to raise and send alert
to the respective person who are not completed the task.

How can i achieve this using Excel?

thks

chitra