I have just started to look at conditional Formatting and am curious if this
is the right approach if so, is it possible to link it with my original
macro or does it need to be seperate?

Scott

"Scott" wrote in message
...
Hi guys,

i also meant to ask if there is any easy way to get rows to colour code
based on date.

i.e. if date is older than 7 days colour Red, if date is older than 7 and
less than 15 colour Blue, if older than 15 colour Yellow.

I had a look on Google but couldn't find an easy wasy to do it.

Regards

Scott