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