Check data and Highlight Differnce before Save

[kannan1847]

Dear members,
I am have excel contains two sheets

Input sheet where users to be Type or copy paste data

Master sheet is the base sheet

My requirement is the user can enter data only which is available in master data,

Example they cannot enter date after given date range and given region

kindly give vba button for highlight wrongly given data after rectify that data only they need to save the sheet

kindly do the needful

[ARowbot]

You can use Excel's data validation tool to do this job...

It is under data and data validation. It is fairly self explanatory.

[kannan1847]

But when copy paste or formula enter it over write..So VBA is better