Hi all,
Apologies if this is in the wrong forum. As part of a spreadsheet I am creating, I will be working within specific timeframes with a large volume of queries. For visibility, I have decided to give myself indication of what a deadline is approaching. Here is what I need excel 2007 to do;
If I put a date in column A1, I need A2 to calculate the date as 40 calendar days into the future. Ideally, I would also like the box to be able to change colour dependant on where the query was up to. As a rough indicator, > 0 but < 14 green / > 14 but < 29 amber / > 29 onwards would be red. After the 40 day period, I suppose I would want it to just... go blank again, unless I had a 'completed' drop down in A3 which would overwrite everything and make it a lighter green. I know I wouldnt always want it to be a red colour after the 40 day time elapsed.
Any experienced excel'ers have any input?
Being new to excel 2007, I am unsure if this is at all feasible, but I thought I would ask. I also did a few forum searches on 'dates' and such but nothing matched my criteria. If there is a matching topic, please feel free to direct me.
Many thanks for any help you can offer.
Dan
Bookmarks