need excel formula to hide or unhide columns based on drop down list.

[Giri.hb]

Hi Team,

Please help me in getting the excel formula to hide or unhide columns based on drop down list.

I tried to do it using conditional formating but not sure what to use in formula section. Kinldy help

For example:

If I select TOM under B1 - it need to show only the columns E:G and L:N. Rest of the columns should hide.
If I select Robert under B1 - it need to show only the columns C:F and M:N. Rest of the columns should hide.

I can do a filter for rows. Kindly help me. Attached sample file for your reference.

[TMS]

Sadly, you cannot hide or unhide columns with Conditional Formatting.

https://excelribbon.tips.net/T009730...ell_Value.html

[Giri.hb]

Thank you for your reply, however I dont want to use VBA or save my file as Macro file. Kindly help me on this, if conditional formating is not works is there any other formula that will work.

[TMS]

… is there any other formula that will work.

No, AFAIK, you cannot hide columns, or rows, with a formula.

What you describe as your requirement would need VBA.

As it stands, I can see no relationship between the columns and the names so, even with VBA, it's not ideal.

[Giri.hb]

Thank you for checking, if no other options. Please help me on VBA code for my sample file.

[JohnTopley]

Please Login or Register  to view this content.

This code goes in Sheet1.

Click "Developer"==>Visual basic==>Sheet1 copy/paste code

[TMS]

I'd be inclined to do it this way:

Please Login or Register  to view this content.