Data validation checks - Automated rules driven

Hi,

plz check the attachment
Book1.xlsx

Ramanhp, thank you for the response, I should have been very clear in my request however;

Using the Data-Validation options is not an option as I will need to run the desired rules against a set of data which is provided to me, generating a list of issues as the validation checks are run and trapping errors.

basically, my team has been handed a process which has a check list of about 80 validation checks, its now almost midnight in London and I am still in work going through them!!!!!

This should be a process which takes about 10 seconds for a VBA program to run through, not 2 hours performed manually!!!!

I can write one for sure in VBA, I just wondered if there was one out there already?

Kevin, I was afraid that you would say that.

I have my own ideas and will probably pursue those, but as you are part way through the process already, at a very high level, what is your approach to this?

Thank you Kevin, apologies for the very late response.

Didn't quite offer what I was hoping but a correct response nonetheless