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