to block unwanted cells when i filter the data in A column

[girishhb]

Hi Team,

Need your help, i have added data validation (T,W,X,Y,Z) in A column, when i select the "T" i need only the B column and the D column to be active and C column should be deactive and if i select "W" only c column to be active . Please let us know if their any option to do this. Please find the example given below. Thanks.

need your help at the earliest.......

[Winon]

Hello girishhb,

And what do you expect to happen if X,Y, or Z is selected?

Regards.

[girishhb]

If x is selected only e column to be active.
If Y is selected only b & C column to be active.
If z is selected only B & E column to be active.

If its not possible, is it possible to highlight the columns as examples given below.

If y selected in the A2 column, the b2 and c2 cells will be highlight with same colour.

The main thing i requested above is to updated the mandatory fields when they select the appropriate data in A column.

please let us know if you need further information. Thanks.

[Winon]

Hello girishhb,

Based on your sample posted, please try the attached Workbook.

Regards.

[girishhb]

Thank u very much it works good.......

[Winon]

Hello girishhb,

You are welcome, glad I could help.

You may also click on the *(Star) to the far left at the bottom of this post, to add to my Reputation.

Regards.