Excel VBA: Highlight/change colour of certain cells depending on value of dropdown list (not conditional formatting)

I’m looking to create a form with some dropdown options in cells L10 and L12. Depending on the value of those cells I’m then looking to highlight certain cells to help the user know which fields are mandatory to be filled then after. This will be for Excel 2003 so I cannot use conditional formatting due to only being able to have 3 therefor it needs to be in VBA.

I’m at a stumbling block and probably overthinking this but can anyone help me please?

Requirements below:

If L10 = yes
Then L12 = yellow

If L12 = yes OR no OR maybe
Then L16, L18, L20, L24, L26 = yellow

If L12 = progress
Then L14, L16, L18, L20, L24, L26 = yellow

If L12 = fail
Then L16, L18 = yellow

If L12 = assess
Then L14, L16, L18, L20, L24, L26 = yellow

If L12 = no
Then L16, L18, L20, L24, L26 = yellow