cell colour changes

[phunter]

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

[teylyn]

color is not data. It is far more complicated to query the color of a cell than its content. If you code the color information into a separate cell, it will be fairly easy to achieve what you want without VBA.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[phunter]

Hi,

I have attached a couple of workbooks, dummy is before, showing the sort of format I need and dummy 2 shows changes once new dates have gone in.

hope this helps

cheers
Paul