How to amend VBA code to make it more dynamic?

Hi,

I'm trying to automate the validation of our MI returns and I use the code below to perform one of the basic checks against the customer code and conditionally format it green if it is valid. The problem I'm experiencing is that each category team has a different supplier template although the header names are the same. How can I amend the code below so rather than starting in cell C2 the macro has to identify which cell has the column header 'customer code ' and effectively make that the C2 equivalent for this MI return.

I hope that makes sense? Basically I want the macro to scan the header names across the columns in row 1, identify which is the 'customer code' and apply the conditional format from row 2 of that column to the bottom of the range.

Thanks in advance,

Snook

HTML Code: