Data Validation in Excel used in Format Range

Hi Experts,

Im just wondering if there's a way i can use format range to carry out the data validation of excel.

i mean, i need to limit the users to enter only numberic data to the input cells, hence they cannot input any letter and negative values.

i tried applying the data validation in format range but, its not spreading the data validation.

if i apply data validation to every cell, when i expand, the data validation disappears.

Any advise.

Thanks much as always...