ruthdennise
New member
- Joined
- Aug 31, 2017
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hello! I am doing a multiple project Gantt chart that looks like this:
The sheet gets its data from another sheet named "DATA" as shown below:
What I want to happen in the ACTUAL PART is when the date for the specific step is equal to the plan, the color of the cell will be GREEN and RED if not. What I did for the actual was I set its default color as GREEN just like this:
The problem is, the code to fill the cell RED if the PLAN and ACTUAL does not match does not work. My code for the RED was this:
=IF(AND(ISEVEN(ROW()),DATA!$C2<>DATA!$C3),AND(DATA!$C2<=C$2, DATA!$C2 >=C$2),0)
The sheet gets its data from another sheet named "DATA" as shown below:
What I want to happen in the ACTUAL PART is when the date for the specific step is equal to the plan, the color of the cell will be GREEN and RED if not. What I did for the actual was I set its default color as GREEN just like this:
The problem is, the code to fill the cell RED if the PLAN and ACTUAL does not match does not work. My code for the RED was this:
=IF(AND(ISEVEN(ROW()),DATA!$C2<>DATA!$C3),AND(DATA!$C2<=C$2, DATA!$C2 >=C$2),0)
