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

...
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 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