I have a formula I am using that is helping set cell values, which then get color coded via conditional formatting.
=IF(AND('3 - Projects'!$C$6="Yes",Week1>=$E$29,Week1<=$F$29),"x",IF(AND('3 - Projects'!$C$6="No",Week1>=$E$29,Week1<=$F$29),"n",""))
I've used the $ symbol to anchor certain references. But when I drag/fill across rows, the week1 reference does not increment. What is preventing it from incrementing automatically during the drag-fill?
As there are 52 columns (weeks in a year) and 25 rows for the respective projects, I'd really like to not have to manually edit all those cells.
=IF(AND('3 - Projects'!$C$6="Yes",Week1>=$E$29,Week1<=$F$29),"x",IF(AND('3 - Projects'!$C$6="No",Week1>=$E$29,Week1<=$F$29),"n",""))
I've used the $ symbol to anchor certain references. But when I drag/fill across rows, the week1 reference does not increment. What is preventing it from incrementing automatically during the drag-fill?
As there are 52 columns (weeks in a year) and 25 rows for the respective projects, I'd really like to not have to manually edit all those cells.