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

=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" <(E-Mail Removed)> wrote in message
news:85daf70f-cae6-4253-a81a-(E-Mail Removed)...
|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

On the issue of Formula Is, you need $$ because the formula in CF is
copied identically to cell formulas.

=$G$8=TRUE

HTH
Kostis Vezerides

On Nov 25, 4:52*pm, gtslabs <gtsl...@comcast.net> wrote:
> 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

Do you need the =TRUE? Wouldn't =$G$8 do it?
--
David Biddulph


"vezerid" <(E-Mail Removed)> wrote in message
news:0d96a887-4538-4c79-8f53-(E-Mail Removed)...
On the issue of Formula Is, you need $$ because the formula in CF is
copied identically to cell formulas.

=$G$8=TRUE

HTH
Kostis Vezerides

On Nov 25, 4:52 pm, gtslabs <gtsl...@comcast.net> wrote:
> 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

Personally I would not put it but I thought that I should maintain the
philosophy the OP used for his formula.

To the OP: Anything numeric and non-zero counts as TRUE in logical
context. Hence, especially since your formula in G8 is logical and
returns TRUE/FALSE, it would be enough to use the simplified formula
as David suggested.

Kostis

On Nov 25, 6:13*pm, "David Biddulph" <groups [at] biddulph.org.uk>
wrote:
> Do you need the =TRUE? *Wouldn't =$G$8 do it?
> --
> David Biddulph
>
> "vezerid" <veze...@act.edu> wrote in message
>
> news:0d96a887-4538-4c79-8f53-(E-Mail Removed)...
> On the issue of Formula Is, you need $$ because the formula in CF is
> copied identically to cell formulas.
>
> =$G$8=TRUE
>
> HTH
> Kostis Vezerides
>
> On Nov 25, 4:52 pm, gtslabs <gtsl...@comcast.net> wrote:
>
> > 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