Have over 500 interchangeable Table headers based on export options selected. These are CSV files that will need to be imported back, but have to meet certain requirements.

Basically I'm looking to create a macro with a check on the table header if table header = X then highlight entire column except the header, and run a conditional format formula to find any invalid entries based what parameters each table header has tied to it.

End goal is to allow me get any CSV fields, run the macro, detect invalid entries pertaining to that field, and turn it red to make adjustments or whatever (fine tuning in the future).