Key Cells

[Panoos64]

Hi to all of you, it would be highly appreciate to advice me how to format from cell A4 till rows down (all rows down), so that to valid only date in format dd/mm/yyyy and also should be key cells so that, if i do not enter the date, should not work in any other cell. Thank you all in advance

 

[alansidman]

On the Ribbon, Data-->Data Tools-->Data Validation

Under Settings, select Date in the combo box
Then in the Data field select how you wish this to be.

 

[Panoos64]

Hi alan, thank you so much, for your advice. Base on above i resolved my issue. Have a great day