Posted to microsoft.public.excel.misc
|
|
Automatically fill in TRUE values
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" wrote in message
...
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))}
|