Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CF using Toggle Button result
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toggle Button | Excel Worksheet Functions | |||
Need to Use 1 Button to toggle On or Off | Excel Discussion (Misc queries) | |||
Toggle Button | Excel Discussion (Misc queries) | |||
Toggle button | Excel Discussion (Misc queries) | |||
Toggle Button | Excel Discussion (Misc queries) |