Hey anyone,
I am having problems trying to work out a macro to hide/unhide a cell based on a value. The value is derived from a IF statement.
Below is the information you may need, any help would be appreciated. I have looked through the forums and used other suggestions for other posts, but none seem to work.
C14= =IF(C10="","",IF(OR(AND(C10="Business Super Directions"),AND(C10="Personal Super Directions")),"Yes","No"))
So, depending on the selection at C10 from a drop down box, C14 will equal the following;
1) BLANK, if C10 option has yet to be selected
2) Yes
3) No
What i am trying to do is the following;
1) BLANK: Show row 15
2) Yes: Show row 15
3) No: Hide row 15
As the value of C14 could change i need the macro to be able to show the above 3 outcomes.
If the cell changes from No to yes, i need it to unhide the cell.
Also, i have seen in some posts, others were having problems with the cell hiding or unhiding unless you hit the enter button.
I am hoping that it is possible for the macro to RUN and hide/unhide purely on the change of value without the need to hit "enter"
Any help would be really appreciated
I am having problems trying to work out a macro to hide/unhide a cell based on a value. The value is derived from a IF statement.
Below is the information you may need, any help would be appreciated. I have looked through the forums and used other suggestions for other posts, but none seem to work.
C14= =IF(C10="","",IF(OR(AND(C10="Business Super Directions"),AND(C10="Personal Super Directions")),"Yes","No"))
So, depending on the selection at C10 from a drop down box, C14 will equal the following;
1) BLANK, if C10 option has yet to be selected
2) Yes
3) No
What i am trying to do is the following;
1) BLANK: Show row 15
2) Yes: Show row 15
3) No: Hide row 15
As the value of C14 could change i need the macro to be able to show the above 3 outcomes.
If the cell changes from No to yes, i need it to unhide the cell.
Also, i have seen in some posts, others were having problems with the cell hiding or unhiding unless you hit the enter button.
I am hoping that it is possible for the macro to RUN and hide/unhide purely on the change of value without the need to hit "enter"
Any help would be really appreciated