Skip to Content
0
Former Member
Oct 20, 2011 at 08:56 AM

Data Validation in Excel used in Format Range

137 Views

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...