Hi, I'm hoping someone can help me with some formulas I need for a work spreadsheet, any advice much appriciated!
So I've got my spreadsheet set up and would like it to highlight when I need to chase up items which have not been returned within a certain timeframe.
I have the date an item has been posted in cell F2. I need cell G2 to show the date the item is due to be returned (this should be 4 weeks after the date in F2). I would also like the cell G2 to be highlighted yellow if the due date is today, orange if it is 1-3 days late and red if it is 4+ days late.
I intend to enter the date the item was recieved in cell H2, so if there is a date value in H2 then G2 would not need to change colour at all.
I hope I have explained this well enough, does anyone know if this is possible and if so how I would go about it?
Many thanks in advance for your help!
So I've got my spreadsheet set up and would like it to highlight when I need to chase up items which have not been returned within a certain timeframe.
I have the date an item has been posted in cell F2. I need cell G2 to show the date the item is due to be returned (this should be 4 weeks after the date in F2). I would also like the cell G2 to be highlighted yellow if the due date is today, orange if it is 1-3 days late and red if it is 4+ days late.
I intend to enter the date the item was recieved in cell H2, so if there is a date value in H2 then G2 would not need to change colour at all.
I hope I have explained this well enough, does anyone know if this is possible and if so how I would go about it?
Many thanks in advance for your help!
