Previous Topic Next Topic

Excel..condition based on drop down list

Closed
Kingleviathan - Sep 25, 2010 at 08:30 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 25, 2010 at 09:04 PM
Hello,

I've created a drop list (using the validation method). in excel 2003.

What I wish to do...

is create a condition where another cell is invisible unless a specific option from the drop list is selected... the drop list has option list words not numerics..

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 25, 2010 at 09:04 PM
try these two macros
s is in the list of validation
one problem is will you remember which cell is hidden so that you can unhide it. 

Sub hide_cell() 
If Selection.Value = "s" Then 
Selection.NumberFormat = ";;;" 

End If 
End Sub



Sub unhide_cell() 
Selection.NumberFormat = "general" 
End Sub
1

Similar discussions

How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
Facebook Messenger - Suggested Friends
jadess_0462 -
Akajackal -

2 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses