Macro to highlight a date in he past.

[organic_hugtime]

I have a fairly large spreadsheet which I use for tracking progress, I have dates in columns D-G in two styles "good" i.e. Green and "bad" i.e. Red, I need a macro that will highlight cells with past dates that are considered "bad" as these should always be future dates. The cells that are considered good are all past dates, and I don't want these highlighting. If that is at all possible?

 

[patel45]

attach a link to a sample file with current and desired sheet

 

[organic_hugtime]

Sorry i am very special when it comes to computers ... how do i attach said file?