I would like to include a feature in my spreadsheet. In cell B2 I have a list form, showing the options “O.P”, “C.P” and “P.S.P”. Underneath in cells B3 to E3 are two rows of the following options “Socials”, “Alert”, “Going” and “Subscription”. Photo below for example.

I have already formatted each of the cells from B3 to E4 to display their respective text, dependent on the value in B2. So when either of the options are selected in the form in B2, the cells underneath will display the same word text. For example, the formula I have used in cell B4 is this “=IF(B2=”O.P”,”Socials”,IF(B2=”C.P”,”Socials”,IF(B2=”P.S.P”,”Socials”,””))) “.

Everything works fine when switching between the forms. What I need to include is a feature where the user can choose any of the options in B2 and colour fill in the cells underneath as they need.

Right now when I do this, the colour filled cells stay the same across all of the options in B2. What I need is for the colour filled cells to stay the same, respective to the option in B2.

Ultimately, if the user is on the “O.P” option in B2, and they colour fill cells B3 and D3, then go to the “C.P” option in B2 and colour fill cells C3 and D3, when they go back to the “O.P” option, cells B3 and D3 will still be colour filled, and when they go back to the “C.P” option, cells C3 and D3 will still be colour filled.

How would I be able to include this feature in my spreadsheet please?

​I would like to include a feature in my spreadsheet. In cell B2 I have a list form, showing the options “O.P”, “C.P” and “P.S.P”. Underneath in cells B3 to E3 are two rows of the following options “Socials”, “Alert”, “Going” and “Subscription”. Photo below for example. I have already formatted each of the cells from B3 to E4 to display their respective text, dependent on the value in B2. So when either of the options are selected in the form in B2, the cells underneath will display the same word text. For example, the formula I have used in cell B4 is this “=IF(B2=”O.P”,”Socials”,IF(B2=”C.P”,”Socials”,IF(B2=”P.S.P”,”Socials”,””))) “. Everything works fine when switching between the forms. What I need to include is a feature where the user can choose any of the options in B2 and colour fill in the cells underneath as they need. Right now when I do this, the colour filled cells stay the same across all of the options in B2. What I need is for the colour filled cells to stay the same, respective to the option in B2. Ultimately, if the user is on the “O.P” option in B2, and they colour fill cells B3 and D3, then go to the “C.P” option in B2 and colour fill cells C3 and D3, when they go back to the “O.P” option, cells B3 and D3 will still be colour filled, and when they go back to the “C.P” option, cells C3 and D3 will still be colour filled. How would I be able to include this feature in my spreadsheet please?  Read More

​