Experation Date

[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

 

[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.

 

[Arlan]

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?