Date Turns Green 90-Days before the date shown in cell


A

ajaminb

The cell fill color is black and the font is white, if the date show is long
before it expires I want it to remain white, at 90-days before the date
shown, it turns green.

I have tried this and I don't get the desired result as express above:
Select the col B | go to format | conditional formatting | condition 2 -
formula
is =B1>(TODAY()-90) | color is picked | and close with, ok

What is happening is the date is turning green if it is before the date shown
 
Ad

Advertisements

S

ShaneDevenshire

Hi,

You want the font to turn green but the fill to be black?

if so,
1. Select the range of dates
2. Choose Format, Conditional Formatting, and in second box choose less than
or equal to and in the third box enter =TODAY()+90
3. Click Format
4. On the Font tab under Color choose Green.
 
A

ajaminb

I tested this and it isn't working. How I tested was by putting a date of
12/30/08 in the field. Today is 9/28/08. I start ticking of a day at a time
and when I get to 12/27/08 it turns green. If I go to 6/27/08 it is still
green. Am I missing something?
 
A

ajaminb

I have applied this and it still is not working. I really appreciate the
assistance because if I can achieve this I will have a tool that will help me
out immensely.

The application is: I have an Excel spread sheet with a column of
expiration dates. I have the column with a "BLACK" fill and the font is
"White". I need all dates to be white and to turn green 90-days before the
entered date and red once the date has passed. You helped me with the red
part and it is working well. If I go back 91 days before the expiration of
the date, it should be white.

I really appreciate this.
--
AjaminB


muddan madhu said:
try this

condition 2 - | =DATEDIF(TODAY(),B1,"D")=90



I tested this and it isn't working. How I tested was by putting a date of
12/30/08 in the field. Today is 9/28/08. I start ticking of a day at a time
and when I get to 12/27/08 it turns green. If I go to 6/27/08 it is still
green. Am I missing something?
--
AjaminB

ShaneDevenshire said:
You want the font to turn green but the fill to be black?
if so,
1. Select the range of dates
2. Choose Format, Conditional Formatting, and in second box choose less than
or equal to and in the third box enter =TODAY()+90
3. Click Format
4. On the Font tab under Color choose Green.
"ajaminb" wrote:
The cell fill color is black and the font is white, if the date show is long
before it expires I want it to remain white, at 90-days before the date
shown, it turns green.
I have tried this and I don't get the desired result as express above:
Select the col B | go to format | conditional formatting | condition 2 -
formula
is =B1>(TODAY()-90) | color is picked | and close with, ok
What is happening is the date is turning green if it is before the date shown
 
M

muddan madhu

is this what u are looking for ?

suppose B1 is your expiration date -
if the expiration date is 28-dec-2008 so it has 90 dates from today
(i.e., from 28-sep-2008 to 28-dec-2008)
in this case the cell font will be in green and fill should be black ?
if it is more than 90 days or less then 90 days then cell font in
white and fille should be black ?
 
Ad

Advertisements

B

Barb Reinhardt

Is it possible that one of your dates really isn't a date? In an adjacent
column, put this

=TEXT(A1)

where A1 is the cell with the date. If you get TRUE, that's at least part
of your problem.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.
 
Ad

Advertisements

A

ajaminb

Yes, with regard to the Green and the Sept 28 2008 - Dec 28, 2008.

Once the date expires, I'm having it turn red, and you showed me how to do
this.

Thank you,
--
AjaminB


muddan madhu said:
is this what u are looking for ?

suppose B1 is your expiration date -
if the expiration date is 28-dec-2008 so it has 90 dates from today
(i.e., from 28-sep-2008 to 28-dec-2008)
in this case the cell font will be in green and fill should be black ?
if it is more than 90 days or less then 90 days then cell font in
white and fille should be black ?





I have applied this and it still is not working. I really appreciate the
assistance because if I can achieve this I will have a tool that will help me
out immensely.

The application is: I have an Excel spread sheet with a column of
expiration dates. I have the column with a "BLACK" fill and the font is
"White". I need all dates to be white and to turn green 90-days before the
entered date and red once the date has passed. You helped me with the red
part and it is working well. If I go back 91 days before the expiration of
the date, it should be white.

I really appreciate this.
--
AjaminB

muddan madhu said:
condition 2 - | =DATEDIF(TODAY(),B1,"D")=90
I tested this and it isn't working. How I tested was by putting a date of
12/30/08 in the field. Today is 9/28/08. I start ticking of a day at a time
and when I get to 12/27/08 it turns green. If I go to 6/27/08 it is still
green. Am I missing something?
You want the font to turn green but the fill to be black?
if so,
1. Select the range of dates
2. Choose Format, Conditional Formatting, and in second box choose less than
or equal to and in the third box enter =TODAY()+90
3. Click Format
4. On the Font tab under Color choose Green.
"ajaminb" wrote:
The cell fill color is black and the font is white, if the date show is long
before it expires I want it to remain white, at 90-days before the date
shown, it turns green.
I have tried this and I don't get the desired result as express above:
Select the col B | go to format | conditional formatting | condition 2 -
formula
is =B1>(TODAY()-90) | color is picked | and close with, ok
What is happening is the date is turning green if it is before the date shown
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top