VBA to help highlight missing mandatory data

Hi

I wanted to see if there is any VBA code that can help me with my query. I have a workbook with multiple tabs containing employee data such as personal data in one tab, address, phones etc in other tabs. In each tab there are a number of mandatory columns which will have the word “Mandatory” in a cell under the column heading, I wanted to see if there is way I can run a VBA macro that will loop through all the tabs in a workbook and for every mandatory columns to highlight in red the cell if the data is missing. The number of rows and columns (including mandatory columns) in each tab could be different.

Many thanks

This can be done with conditional formatting pretty easily, no VBA needed

Yes I did think of conditional formatting but the issue is I have lots of workbooks, I wanted to run the macro against each workbook separately and check for missing data. With conditional formatting I believe I would need to write the rule in every workbook?

You have multiple workbooks or worksheets?
And yes you have to write formatting formula's for individual sheets.

I have multiple workbooks with multiple worksheets in each workbook. There are other validation checks I need to do too such as making sure dates are entered in date fields etc but I thought if I start with checking the missing data first and then can build on it.