VALIDATION MACRO.xls

I've been trying to figure this out on my own for a while, but as a VBA novice I can only get so far... I've written out the logic of what I'm trying to accomplish below. Thanks in advance for any help you can provide! The sheet I have provided is what the final product should look like. The only column I am looking to edit is column C (columns A, B, D, and E are fixed). The cells colored blue contain wildcards (‘XX’ or ‘XXXX’).

** After the macro is complete, if you were to filter column D for “YES” and column E for “NO” all cells in column C would either be green or red (no blanks).**

1. I want to create a loop to find all cells in column A formatted with four wildcards (i.e. 05XXXX) where both column D and E contain “Yes”. Then it would sift through all cells in column A beginning with the first 2 numbers called out (i.e. ‘05’). Any cell in column A that begins with 05 where the respective cell in column D contains “Yes” and column E contains “No” would indicate that the column C should be highlighted green with the text “OKAY”.

2. The same process would be followed for cells with only two wildcards (i.e. 0118XX). In the example file, 0118XX would cause column C respective to ‘011800’ to be highlighted green with the text “OKAY”.

3. At this point, any remaining cells where column D contains “YES” and column E contains “NO” should be highlighted red with the text “NOT OKAY”.