ExcelBanter - Conditional Formating Based on Date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formating Based on Date (https://www.excelbanter.com/excel-discussion-misc-queries/30404-conditional-formating-based-date.html)

Conditional Formating Based on Date

Hi,

I need some help on conditional formating. What I want to do is change the
color of a cell based on the date, i.e. if the date in the cell is today or
greater I want the cell color to change to red, if the date is 3 days before
the date in the cell I want it to change color to yellow.

Use a formula of

=A1=TODAY()

and another of

=A1=TODAY()-3

assuming your cell is A1

--
HTH

Bob Phillips

"Roy" wrote in message
...
Hi,

I need some help on conditional formating. What I want to do is change
the
color of a cell based on the date, i.e. if the date in the cell is today
or
greater I want the cell color to change to red, if the date is 3 days
before
the date in the cell I want it to change color to yellow.

Thanks, this worked, however I have another issue with this. The cell that
is changing color is the due date, but if I put in a date in the completed
cell i want the due date cell to change to green. I have tried under
conditional formating - formula is if(o120), but the color did not change to
green. I even tried to this formula if(o12n12) and the color still did not
change. I am trying to close the loop so that the due date does not change
to red or yellow after there is a date completed in cell O12.

"Bob Phillips" wrote:

Use a formula of

=A1=TODAY()

and another of

=A1=TODAY()-3

assuming your cell is A1

--
HTH

Bob Phillips

"Roy" wrote in message
...
Hi,

I need some help on conditional formating. What I want to do is change
the
color of a cell based on the date, i.e. if the date in the cell is today
or
greater I want the cell color to change to red, if the date is 3 days
before
the date in the cell I want it to change color to yellow.

Use

=AND(O12<"",A1=TODAY())

etc.

--
HTH

Bob Phillips

"Roy" wrote in message
...
Thanks, this worked, however I have another issue with this. The cell
that
is changing color is the due date, but if I put in a date in the completed
cell i want the due date cell to change to green. I have tried under
conditional formating - formula is if(o120), but the color did not change
to
green. I even tried to this formula if(o12n12) and the color still did
not
change. I am trying to close the loop so that the due date does not
change
to red or yellow after there is a date completed in cell O12.

"Bob Phillips" wrote:

Use a formula of

=A1=TODAY()

and another of

=A1=TODAY()-3

assuming your cell is A1

--
HTH

Bob Phillips

"Roy" wrote in message
...
Hi,

I need some help on conditional formating. What I want to do is
change
the
color of a cell based on the date, i.e. if the date in the cell is
today
or
greater I want the cell color to change to red, if the date is 3 days
before
the date in the cell I want it to change color to yellow.

Conditional Formating Based on Date

How would I do a Conditional Formating for dates with a between statement for
three different conditions. With today being 06/07/06, the 1st date of
05/24/06 is between today()-4 and today()-15. 06/05/06 is between today()-3
and today()+3. 06/05/06 is between today()+4 and today()+60.

Today: 06/07/06

05/24/06 -14 (hi-lighted in Blue)
06/05/06 -2 (hi-lighted in Yellow)
07/26/06 +49 (hi-lighted in Orange)

"Bob Phillips" wrote:

Use a formula of

=A1=TODAY()

and another of

=A1=TODAY()-3

assuming your cell is A1

--
HTH

Bob Phillips

"Roy" wrote in message
...
Hi,

I need some help on conditional formating. What I want to do is change
the
color of a cell based on the date, i.e. if the date in the cell is today
or
greater I want the cell color to change to red, if the date is 3 days
before
the date in the cell I want it to change color to yellow.