Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Roy
 
Posts: n/a
Default 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.
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

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.



  #4   Report Post  
Roy
 
Posts: n/a
Default

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.




  #5   Report Post  
Bob Phillips
 
Posts: n/a
Default

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.








  #6   Report Post  
Posted to microsoft.public.excel.misc
AFSSkier
 
Posts: n/a
Default 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting Based on Date John F.M. Excel Discussion (Misc queries) 1 June 2nd 05 08:14 PM
Subtract a group of cells from a total based on ending date Nicholas Scarpinato Excel Discussion (Misc queries) 0 May 17th 05 03:25 PM
Conditional Formating based on another cell SMac Excel Discussion (Misc queries) 5 March 10th 05 08:17 PM
Conditional formating w/ Date Steven Stadelhofer Excel Worksheet Functions 1 February 3rd 05 06:29 PM
conditional formating - Highlighting text cells based on sales res ANDREW_B Excel Discussion (Misc queries) 7 December 2nd 04 05:27 PM


All times are GMT +1. The time now is 01:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"