Hi.
I have a simple sheet that I would like to format according to dates that are inputted in some columns.
If you see the attached file:
I have currently just manually entered the '1' figure corresponding to the dates dictated in columns D and E. I would like to have had these populated automatically.
When I have put in a New Finish date, I would like the appropriate cells to have be formatted differently (probably a coloured fill). So, any cell from that date up until the original Finish date to be highlighted.
The collection time would have to be formatted in a further colour, with those dates going out further than the New Finish date. For example, the Fridge Freezer New Finish Date is on 20-Dec-20 - I would like the next two weeks after that to be highlighted in a different colour than has been used for the other cells.
I hope this makes sense.
I would be able to do this myself if all the cells had the dates in them, but I need to be referring to the cells in row 2 - that's where I am having the problem!
Thank You in advance for nay help.
Bookmarks