Hi mangesh,

For Data Validation...

Select the second cell in the activity field, which I'm guessing is in
row 22.
Go DataValidationCustom=NOT(ISBLANK(M21))uncheck the "ignore
blanks" optionOK
Copy that cell then select all of the Activity field cells below it
then Paste SpecialPaste Validation

Ken Johnson