Create option for hide column

Dear All,

I have the question as how can show column when I put some value.

For Example

If I put number 0 at cell B2, then Excel will shows both column Demand V2 and V1 every month.

If I put number 1 at cell B2, then Excel will hide column Demand V2 every month.

If I put number 2 at cell B2, then Excel will hide column Demand V1 every month.

so I have attach file example for this case.



Could you please suggest me how can solve this one?

Thank you in advance.

Dear jefferybrown,

Thank you for your suggestion, but i am not sure that i do something wrong. Because the column does not hide after i put value 1 or 2.

you can see my attached file.

thank you jeffreybrown