New to macros...

[skate]

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

 

[Frank Kabel]

Hi
try using 'Format - Conditional Format' for this. No VBA required. See:
http://www.cpearson.com/excel/cformatting.htm
http://www.contextures.com/xlCondFormat01.html

 

[skate]

Fantastic just what i was looking for.

: