ChillingSabrina
New Member
- Joined
- Jul 30, 2019
- Messages
- 5
Hi, Newbie here!
I've built a spreadsheet to track reports that are on track/due or overdue. I've added IF formulas to show the on track/due/overdue items and used conditional formatting to change the cell colour which is working without any problems.
I have chart to show the volume of items under each heading which is also working until I need to close a completed item.
The chart is still showing items that are overdue even though they are completed. I'm trying to get cell B5 and D5 to change to complete when a date is input into E5 but I can't get anything to work
<tbody>
</tbody>
Can anyone help before I go crazy lol!
Thanks
CS
I've built a spreadsheet to track reports that are on track/due or overdue. I've added IF formulas to show the on track/due/overdue items and used conditional formatting to change the cell colour which is working without any problems.
I have chart to show the volume of items under each heading which is also working until I need to close a completed item.
The chart is still showing items that are overdue even though they are completed. I'm trying to get cell B5 and D5 to change to complete when a date is input into E5 but I can't get anything to work
Two Weeks | Four Weeks | Completed Date | |||
Completed Date | |||||
12/08/2019 | On Track | 27/08/2019 | On Track | FALSE | |
16/07/2019 | Overdue | 30/07/2019 | Due | FALSE | |
14/06/2019 | Overdue | 28/06/2019 | Overdue | 30/07/2019 | TRUE |
15/07/2019 | Overdue | 29/07/2019 | Overdue | FALSE |
<tbody>
</tbody>
Can anyone help before I go crazy lol!
Thanks
CS