=G8=TRUE should work fine as a CF formula.

You'd need a macro to change the button's caption. Double click the button
while you're in design mode and write code like this:

Private Sub ToggleButton1_Click()
If Range("G8").Value = True Then
ToggleButton1.Caption = "Hide"
Else
ToggleButton1.Caption = "Show"
End If
End Sub

You might have to flip the logic I used. Also, better to use a range name
for cell G8 so if you insert a row, etc., the code still works.

--
Jim
"gtslabs" wrote in message
...
|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