HOW TO INSERT "CONDITION" IN DATES BY EXCEL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You want conditional formatting (Format>Conditional Formatting...)

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

=today()-a1<=30 set color to red
etc.
 
I would suggest using conditional formating and use a formula with three
conditions in this order if the date is in A1:

=$A$1<TODAY()-45 set fill color blue
=$A$1<TODAY()-30 set fill color yellow
=$A$1<=TODAY() set fill color red
 
Back
Top