magnus.er1
New member
- Joined
- Jan 9, 2017
- Messages
- 11
- Reaction score
- 0
- Points
- 0
Hello.
I have got help from you guys by solving the issue of marking a cell with a (X) in the cell range of start and end date , now i would like to add an additional column named "new end date" and in the gant schedule all cells should be marked with (Y) from the "end date" to the new end date.
I will then use conditional formating to color code dependent on if it´s a Y or a X. but thats the simple task (no need for help there
The the formula i am using is
=IF(AND(K$3>=$F5;K$3<=$G5);"X";"") to mark (X) in cells from start to en date
and i would like to add something like this to the formula but does not know how to combine these two
=IF($A2=B$1;"Y";"")
Please look at attached example for deeper understanding.
Thanks in advance Magnus
I have got help from you guys by solving the issue of marking a cell with a (X) in the cell range of start and end date , now i would like to add an additional column named "new end date" and in the gant schedule all cells should be marked with (Y) from the "end date" to the new end date.
I will then use conditional formating to color code dependent on if it´s a Y or a X. but thats the simple task (no need for help there
The the formula i am using is
=IF(AND(K$3>=$F5;K$3<=$G5);"X";"") to mark (X) in cells from start to en date
and i would like to add something like this to the formula but does not know how to combine these two
=IF($A2=B$1;"Y";"")
Please look at attached example for deeper understanding.
Thanks in advance Magnus