Related:
- Conditionally hide columns in excel
- Conditional hide column excel - Best answers
- Conditional hiding - Best answers
- Excel conditional formatting column vs column - How-To - Excel
- Excel Macro help, hiding columns ✓ - Forum - Excel
- How to conditional format two columns in excel ✓ - Forum - Excel
- Excel conditional formatting column ✓ - Forum - Office Software
- How to apply conditional formatting to entire column in excel ✓ - Forum - Excel
2 replies
venkat1926
- Posts
- 1862
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- July 30, 2015
i am rephrasing it
1. if type 1 in A1 column E should be hidden
2. If I type any other number column E should be visible
in that case
right click sheet tab and click view code
in the window that comes up copy this EVENT CODE
now type some number in A1. if it is 1 colum E will be hidden
if it some other number the column E will not be hidden
if you enter in any cell other than A1 nothing will happen
do some experiments.
1. if type 1 in A1 column E should be hidden
2. If I type any other number column E should be visible
in that case
right click sheet tab and click view code
in the window that comes up copy this EVENT CODE
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$1" Then Exit Sub
If Target = 1 Then
Range("e1").EntireColumn.Hidden = True
Else
Range("e1").EntireColumn.Hidden = False
End If
End Sub
now type some number in A1. if it is 1 colum E will be hidden
if it some other number the column E will not be hidden
if you enter in any cell other than A1 nothing will happen
do some experiments.
Subscribe To Our Newsletter!
