Greetings,
I have successfully (with help from this board) been able to conditionally format cells based on their proximity to a due date (green, red, yellow). What my manager wants is if we get behind (and the cells turn red) but then we catch up again, if all of the cells can change to green (suggesting we are back on track)
For example, if these were all tiny parts to one big project:
Cell 1 - Due Monday - Completed Tuesday - Red
Cell 2 - Due Wednesday - Completed Thursday - Red
Cell 3 - Due Friday - Completed Thursday - Green
Since 3 was early, it effectively puts the project back on track. As a result, I would like all of the cells to turn green instead of Red, Red, Green which makes the project look off track.
Right now I have it formatted in based on date inputted, if no date, then the colour of the cell changes based on today's date.
Any help/guidance is much appreciated.
Best,
R
I have successfully (with help from this board) been able to conditionally format cells based on their proximity to a due date (green, red, yellow). What my manager wants is if we get behind (and the cells turn red) but then we catch up again, if all of the cells can change to green (suggesting we are back on track)
For example, if these were all tiny parts to one big project:
Cell 1 - Due Monday - Completed Tuesday - Red
Cell 2 - Due Wednesday - Completed Thursday - Red
Cell 3 - Due Friday - Completed Thursday - Green
Since 3 was early, it effectively puts the project back on track. As a result, I would like all of the cells to turn green instead of Red, Red, Green which makes the project look off track.
Right now I have it formatted in based on date inputted, if no date, then the colour of the cell changes based on today's date.
Any help/guidance is much appreciated.
Best,
R
