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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"skate " schrieb im Newsbeitrag
...
Hi can anyone tell me if this is possible and how difiicult:

I have a database of date drawn from an external online database on
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 coloured
red - i know when the record was created as i have created a column
named EVENT_CREATED which holds the date the online record was
created....

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

Cheers for any help

:)
KAte


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

Fantastic just what i was looking for.

:

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