Hi all,

I'm looking for some ideas on the best way to validate an excel spreadsheet that I will routinely receive.

Here's are the rules that it will need to check for: I'm not sure if a VBA Macro is the best way to go. In addition, there are several rules and I'm a bit rusty on implementing these rules. Any help from the group is greatly appreciated.

1 - Check if specific column contains only a "0" if so - then highlight, if not then check if specific column contains less than 9 digits, if so, then highlight a different color.

2 - Check if date format for a specific column is yyyy-mm-dd

3 - Check if there are duplicate for a specific column, if so, then highlight

4 - Check if specific column only contains "M" or "F" (must be case sensitive) if not, then highlight

5 - Check if headers match a template provided from another sheet. For example if template has 5 columns and the sheet we receive has 6 columns, that means an extra column was added which should be highlighted.

6 - Check if a specific column contains only the following values : "hispanic", "non-hispanic" or it can be null

7 - Check if a specific column does not contain "#" if so, then remove and replace with white space


Thank you in advance for your help..