I have attached a sample file to help show what I am about to explain. I am trying to make a tool that will check a weekly generated report for errors.

Check Values Sample File.xlsx

I need a code that will check column A for the value "Employee". If "Employee" is found, then check column B for a job name. If there is no value, then continue to the next "Employee" value in column A. If there is a value, then check column C for the Labor Type. Take the Labor Type value and look on 'Sheet2' to find the matching Job and Labor Type value and make sure the Rate on 'Sheet1' in column D is the same as 'Sheet2' column C. If the value is not the same, then I would like to turn the rate in 'Sheet1' red to show the error.

In my sample file, I only have 3 employees, 2 jobs, and 2 labor types. These three lists will be a different length each week. So I am hoping this can be a dynamic code.

Is this possible to achieve?

Thank you very much!