Hi can anyone tell me if this is possible and how difiicult:

I have a database of date drawn from an external online database o
opening a document.

Unfortunately i need a colour code on the data these would be:

if the record is a month of less old then the data would be coloure
red - i know when the record was created as i have created a colum
named EVENT_CREATED which holds the date the online record wa
created....

Could i get a macro to look loop throung the records and look for an
record with a date < a month in the past and colour the row tex
red???

Cheers for any help

:)
KAt

--
Message posted from http://www.ExcelForum.com