Experation Date

  • Thread starter Thread starter Arlan
  • Start date Start date
A

Arlan

I have a column in which I have different expiration Dates. I would like the
box to change color to amber when today's date is 90 days from the expiration
date and then red when 30 days from the expiration date. The actual formula
would be most useful.

Thank you in advance.
Arlan
 
Calendar days, and yes the color should stay "Amber" until 30 days out and
then turn to "Red". I hope I am explaining everything corectly.
 
I'm not sure if I am doing this right. I went into "managing rules" and made
two new rules as you indicated (copied and pasted). When I apply the rules no
matter what date is in the field "Red" fills the block?
 
Back
Top