Automatically fill in TRUE values
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))} |
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))} |
Automatically fill in TRUE values
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" 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))} |
All times are GMT +1. The time now is 05:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com