Looking for advise on how to accomplish the task below. I have researched this and found many different ways of doing this but nothing that I found actually worked.

1st Example:

If I choose "C" License from a drop down list of cells in C5:C8

It should automtically change the cells in B20, F20, J20, N20, R20 & V20 with the input of to "C" License on each of those cells.

All these cells now will show "C" License with the background fill color to match that "C" license which is organge fill color.

2nd: Example:

If I choose 3 Years form a dropdown list of cells in 5:G8

It should automaticly change the cells in B22, F21, J21, N21, R21 & V21 with the input of to 3 Years on each of those cells.

All these cells now will show 3 Years with the background fill color to match that 3 Years which is gray fill color.

3rd: Example:

Cells B23:X26 are manual enteries. When entering the manual enteries in B23:X26 the cells background fill color should match the fill color of what was choosen from the dropdown list of G5:G8 .

If I choose 3 Years cells B23:X26 will have the background fill color of gray to match the background fill color of 3 Years.