Changing the value of multiple cells by clicking on cell B4

[LondonTeacherUK]

Hi guys,

I'm wanting to click on B4 and to have cells B8 to B36 change to the following:

Value = "Operate video camera, record a detailed and informative audio commentary"
Color = RGB(255, 255, 0)

I've tried mashing together various solutions from different places but despite my best efforts, nothing seems to be working. If anyone could help me with this I would be very grateful!

Thanks

 

[LondonTeacherUK]

Thanks for all your help.