G
gtslabs
I am trying to use CF to hide some cells (actually turning the font
color white).
I made a Control Toggle Button and linked it to cell G8.
The cells I want to hide are say B2...B6
I select that range and goto Conditional Formating
2 Questions:
1) How do I write the "formula is" CF expression testing if G8 is TRUE
or FALSE?
I tried G8=TRUE but that is not working.
2)How do I change the caption of the Toggle Button to show different
text if depressed or not.
So I want it to say SHOW and HIDE
color white).
I made a Control Toggle Button and linked it to cell G8.
The cells I want to hide are say B2...B6
I select that range and goto Conditional Formating
2 Questions:
1) How do I write the "formula is" CF expression testing if G8 is TRUE
or FALSE?
I tried G8=TRUE but that is not working.
2)How do I change the caption of the Toggle Button to show different
text if depressed or not.
So I want it to say SHOW and HIDE