Hello,
I am not so good with excel, but trying to learn
I am struggling with the following - I want to create a sheet, that contains 6-7 columns. The first one will be a List of products to choose from. Depending on the choice, some or all of the other cells in the row will be enabled (ex. in column A we have the list - 1.TV, 2. Toaster, 3 PC, 4. Mobile. If you choose "TV", then cells B to F will be enabled, but if you choose "PC", only cells B, E and F will be enabled, the others remain disabled). I had some success by using data validation and conditional formatting, however I was able to do this for only one product (=A2="TV"). Is there a possibility to specify more than one word, for example =A2="TV","Mobile"?
Thanks in advance.
I am not so good with excel, but trying to learn
I am struggling with the following - I want to create a sheet, that contains 6-7 columns. The first one will be a List of products to choose from. Depending on the choice, some or all of the other cells in the row will be enabled (ex. in column A we have the list - 1.TV, 2. Toaster, 3 PC, 4. Mobile. If you choose "TV", then cells B to F will be enabled, but if you choose "PC", only cells B, E and F will be enabled, the others remain disabled). I had some success by using data validation and conditional formatting, however I was able to do this for only one product (=A2="TV"). Is there a possibility to specify more than one word, for example =A2="TV","Mobile"? Thanks in advance.
