Is there a way to fill in the cells between two TRUE statements
Example:
C2=TRUE, D2=FALSE, E2=FALSE,F2=FALSE,G2=TRUE

I would like D2,E2,F2 to all change to TRUE and I would also like to add it
to the formula that makes the cells TRUE in the first place. Here is my
formula:
{=OR(IF($D2=$CG$2:$CG$32,1,0),IF($E2=$CG$2:$CG$32,1,0))}

Which cells have formulas and what are they?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Ron St Jean" <(E-Mail Removed)> wrote in message
news:F5D00947-7B5F-4A1A-A325-(E-Mail Removed)...
> Is there a way to fill in the cells between two TRUE statements
> Example:
> C2=TRUE, D2=FALSE, E2=FALSE,F2=FALSE,G2=TRUE
>
> I would like D2,E2,F2 to all change to TRUE and I would also like to add
> it
> to the formula that makes the cells TRUE in the first place. Here is my
> formula:
> {=OR(IF($D2=$CG$2:$CG$32,1,0),IF($E2=$CG$2:$CG$32,1,0))}

All of the cells have formula's and they are the formula that I have shown
below.

"Bernard Liengme" wrote:

> Which cells have formulas and what are they?
> --
> Bernard V Liengme
> Microsoft Excel MVP
> http://people.stfx.ca/bliengme
> remove caps from email
>
> "Ron St Jean" <(E-Mail Removed)> wrote in message
> news:F5D00947-7B5F-4A1A-A325-(E-Mail Removed)...
> > Is there a way to fill in the cells between two TRUE statements
> > Example:
> > C2=TRUE, D2=FALSE, E2=FALSE,F2=FALSE,G2=TRUE
> >
> > I would like D2,E2,F2 to all change to TRUE and I would also like to add
> > it
> > to the formula that makes the cells TRUE in the first place. Here is my
> > formula:
> > {=OR(IF($D2=$CG$2:$CG$32,1,0),IF($E2=$CG$2:$CG$32,1,0))}
>
>
>