Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Experation Date
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Experation Date
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Experation Date
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Experation Date
Supposing your exp date is in A1, use following conditional formats for cell A1 =and(today()-A1<=90,today()-A130) ( and set your format to "amber") and as 2nd condition =today()-A1<=30 ( and set format to "red") Arlan;274865 Wrote: 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: 'The Code Cage Forums - View Profile: Pecoflyer' (http://www.thecodecage.com/forumz/me...pecoflyer.html) View this thread: 'Experation Date - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=76610) -- 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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Experation Date
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? "Pecoflyer" wrote: Supposing your exp date is in A1, use following conditional formats for cell A1 =and(today()-A1<=90,today()-A130) ( and set your format to "amber") and as 2nd condition =today()-A1<=30 ( and set format to "red") Arlan;274865 Wrote: 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: 'The Code Cage Forums - View Profile: Pecoflyer' (http://www.thecodecage.com/forumz/me...pecoflyer.html) View this thread: 'Experation Date - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=76610) -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
highlight records on experation date( Excel 2003) | Excel Discussion (Misc queries) | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |