Hi,
I would like some help in writing a macro to allow a few things to happen within a excel worksheet.
I have a spreadsheet detailing when something has been completed, and into a cell you will put a date and change cell colour, if green, then I would like the macro to input a date +84 days to the date that has been inputted, in a cell 3 to the right of it, and change that cell colour to blue, which to me would indicate the next due date.But if the colour was red then it needs a date +30 into the cell next to it on the right.
What I also need is it to ignore placing the blue cell if you then change that to green, i.e it's been completed.
I need this to look at all cells within workbook, if cell is a date.
any help would be appreciated.
cheers
Paul
Bookmarks