write a vba code to update cells backgroud based on lookup and cells data

Please watch video before posting a response and let me know you have watched it:
https://screencast-o-matic.com/watch/crlYIlV2Kn1

I have an Excel spreadsheet that I need a macro writing to update the background of cells in a row depending on the value selected from a drop down and a lookup of the column header in another sheet.

The cell background should change to yellow if the heading for that cell is in a certain sheet.

Please watch the video for a full explanation before posting a response and let me know you've watched it so you understand the project.
https://screencast-o-matic.com/watch/crlYIlV2Kn1

Many thanks