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

 

[Pecoflyer]

Hi,
are you talking about calendar days or working days?
Should the colour stay from exp_date-90 till exp_date-30?

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

Thank you in advance.
Arla

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

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

 

[Pecoflyer]

Supposing your exp date is in A1, use following conditional formats fo
cell A
=and(today()-A1<=90,today()-A1>30) ( and set your format to "amber")
and as 2nd condition
=today()-A1<=30 ( and set format to "red"

Calendar days, and yes the color should stay "Amber" until 30 days ou
an
then turn to "Red". I hope I am explaining everything corectly





(http://www.thecodecage.com/forumz/showthread.php?t=76610

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

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