Hi folks.

I have a spreadsheet that contains text, values and dates between
columns 'B' and 'I'. What I'd like to do is have formatting set
somewhere, so that if the value in the date column is more than two
weeks older than the date the file is opened, it should colour the
text from column 'B' to 'I' on the row red.

If the date is between 1 and 2 weeks in the past, it should colour the
text orange. If it is within 7 days old, it should colour it green.
If the date field is blank, the text colour should be black.

I don't fancy doing this via condiitonal formatting, as I'm thinking
you'd have to put this in each cell. Also, as I'm using Excel 2003,
you can only have 3 condiitonal formats...or would this be enough?
However, as I say, I'm not keen on having to put this formatting in
each cell.

Anyone know of a way to do this?

Duncs