Formatting conundrum

Originally Posted by scunni

Hi guys, wonder if anyone can help me with this one. Been contemplating it for ages but can't for life of me think how (if) it can be done:

Simple scenario: Within spreadsheet I have a number of cells which contain planned dates & similar set of cells which will contain either actual or forecast dates. Idea is 'planned' date cells are completed once and once only, others are updated on a regular basis. However, what I want to be able to do initially when there are no actual/revised dates is to duplicate the relevant planned dates into the relevant corresponding actual/planned cells. These would then be manually overwritten as actual/planned dates become available. Yes, the duplication bit is easy BUT what I want is for those cells which have not yet been overwritten i.e. still contain the original planned dates to be displayed in maybe a different colour etc. Note that some of the actual/revised dates may still be the same as the original planned dates - these would still be input into the relevant cells so overwriting the original fill.

Any solution has to be able to work in both Excel 97 and XP/2003 - all ideas would be thankfully received, it's driving me mad thinking if/how can do it.

In the tab for your worksheet, rightmouse and select View Code, and copy this code into there.

Please Login or Register  to view this content.

For the lines that start 'Msgbox - you can remove the ' to test, and remove the lines when you are finished testing.
Set your range, currently set to D2:D12, and your colour, currently set to 3 (red)

note, by 'original fill' I presumed something like C2 had the date, and D2 had =C2 as it's formula, which was overwritten by the date when one was achieved.
hth
---
added, after the Else, if you use other cell colours in this range, you can amend to

Please Login or Register  to view this content.

---

Originally Posted by scunni

Thanks for quick response Bryan, your code solved my problem.

Many thanks
SteveC

Correctly that should be

Please Login or Register  to view this content.

- I missed the 'Interior' from the added line test.

hth
---