Hello guys,
I have a worksheet where:
Cell D5 = Start Date (example, 31/01/2017)
Cell E5 = End Date (example, 19/02/2017)
Then, i have a table with the entire calendar of the year going to the right. What i need is to colour the cells between the Start Date and End Date.
So, for example, the Start Date 20/01/2017 is Cell "AJ4" and the End Date is in cell "BC5". The Cells in between are coloured in green. I want a macro that colours this automatically according to the values in Cells D5 and E5.
I have attached a worksheet.
How can i do this?
Bookmarks