Posted May 30, 201212 yr FPCH Admin Hi Guys, not sure whether anyone can help with this but i will try anyway, i have created a spreadsheet as per below: Ticket Number Work awaiting Original Due Date Status 2758 HLE 07/06/2012 8.00 Days 2498 HLE 31/05/2012 1.00 Days 2845 HLE 28/05/2012 -2.00 Days the columns are A,B,C,D. The Status coloumn needs to be able to calculate the difference between todays date and the due date, the Status coloumn needs to show the amount of days remaining and a minus if its overdue but also if the Status is 4 days or more away the cell is filled green, if it is 1-3 days away the cell needs to fill Amber and if it is 0 or a minus amount of days it needs to fill the cell Red, but you still need to see the information. any ideas guys? Thanks Brad View this thread Off Topic Forum - Unlike the Rest
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.