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" wrote:


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

Arlan;274696 Wrote:
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

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=76610