Automatically populate cells with selection from drop down list

I have tried and researched how to accomplish this and can not get it to work. Can someone guide me in how to too this.

Thanks

1st

I want cells B20, F20, J20, N20, R20& V20 to automaticly update with theselection that was chosen from a drop down list in C3:C8.
If Ichoose C License from the drop downlist of information in cells in C3:C8
It should automatically update the cells inB20, F20, J20, N20, R20 & V20 withthe input of C License on each of those cells.

All the above cells now will show CLicense with the background fill color to match that C license which is orange fill color.

2nd.
I want cells B21, F21, J21,N21, R21 & V21 to automaticallyupdate with the selection that was chosen from a drop down list in G3:G8.
If I choose 3Years form a dropdown list of information in cells in G3:G8
It shouldautomatically change the cells in B22, F21, J21, N21, R21 & V21 with the input of to 3 Years on each of those cells.
Allthese cells now will show 3 Yearswith the background fill color to match that 3 Years which is gray fill color.

3rd
Cells B23:X26 are manual entries. When entering the manualentries in B23:X26 the cells background fill color should match the fill colorsof B21, F21, J21, N21, R21 & V21 ofwhat was chosen from the dropdown list of G5:G8 .
See 2^nd example
If I choose 3Years cells B23:X26 will have the background fill color of gray to match the background fill colorof 3 Years.

Re: Automatically populate cells with selection from drop down list

I have a workbook that I can send that shows the efforts that I tried and did not work.

How do I send the workbook? I do not see where I can send the attachment?