You want conditional formatting (FormatConditional Formatting...)

You can set up to three conditions, so you would use something like:

=today()-a1<=30 set color to red
etc.

--
Regards,
Fred


"Excel" wrote in message
...
I wanna insert a formula with dates in which I need 3 different colours. Eg.
until 30 days ago, the sentence has to be red, 31 to 45 days ago, the
sentence has to be yellow and before 45 days ago, e.i. 46 days ago or more,
the sentence has to be blue.
Thanks.
Alves