Excel data validation

I have an MS excel which is to be uploaded to a software. In excel there are around 65 columns. User will copy paste data in this excel from other excel or systems. Requirment - [login to view URL] upload conditional formatting which will highlight cells which do not fits validation criteria so as to give warning. 2. It should allow copy paste from other excel 3 It should be user freindly 4. Open to macro Each column has different validation condition for eg 1. Text Fields - Max or Min length 2. Number fields - Max Amount/Min Amount. with restriction on 2 decimal 3. Date fields - Restriction only on future date or only on past dates or dates older than 2 months 4. Drop down fields - Data should be one of that of drop down 5. Conditional Field - Few fields would be mandatory/optional based on value on other columns 6. etc