Conditional Formating a whole spreadsheet

[TORBABY]

I am really stuck at the moment when i am trying to conditional format a spreadsheet in Excel 2003.
I am able to set each cell up with 3 formats to change colour when the date in it goes above a certain amount of days (e.g 365, 90 or 30 days)
However the size of my spreadsheet makes this impossible to do with one cell at a time as this will take days. Is there any way that i could set the format so it would do a row at a time or even the whole spreadsheet?

I can send a copy of part of the spreadsheet that i am using if this will help.

Thanks!

 

[TORBABY]

and this will work when i am using the format painter or will i have to do the cells individually?

 

[VoG]

It should work with the format painter.