Making cells change color after a specified period of time.

[Mike]

I am making a tracking data base and I would like to make
certain cells change color when a date in that row is
beyond a certain time frame. This will be used to
quickly identify overdue and upcoming events. Thanks in
advance.

Mike

 

[GerryK]

Mike
as an example:
=IF(TODAY()-A1>14,"CHECK","")then Conditional Formatting
to include something like [Cell Value is][equal to]
[="CHECK"]choose your colors.
HTH

in the [dialoque] boxes

 

[Lisa]

Highlight the column or cell you wish to change and use
the Conditional Formatting option. Good Luck!

 

[Bob Phillips]

If you want to colour all cells that meet that criteria, use this slightly
modified version

=IF(TODAY()-$A$1>14

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Mike
as an example:
=IF(TODAY()-A1>14,"CHECK","")then Conditional Formatting
to include something like [Cell Value is][equal to]
[="CHECK"]choose your colors.
HTH

in the [dialoque] boxes

-----Original Message-----
I am making a tracking data base and I would like to make
certain cells change color when a date in that row is
beyond a certain time frame. This will be used to
quickly identify overdue and upcoming events. Thanks in
advance.

Mike
.

 

[Mike]

That helped out alot, but if I put a formula in a cell
then I can not have data in that cell, correct. And how
do I make the Conditional formatting to include a whole
row of date for making it change color. Thanks

-----Original Message-----
Mike
as an example:
=IF(TODAY()-A1>14,"CHECK","")then Conditional Formatting
to include something like [Cell Value is][equal to]
[="CHECK"]choose your colors.
HTH

in the [dialoque] boxes

-----Original Message-----
I am making a tracking data base and I would like to make
certain cells change color when a date in that row is
beyond a certain time frame. This will be used to
quickly identify overdue and upcoming events. Thanks in
advance.

Mike
.

.

 

[Bob Phillips]

Select the whole row and use the updated formula I posted.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

That helped out alot, but if I put a formula in a cell
then I can not have data in that cell, correct. And how
do I make the Conditional formatting to include a whole
row of date for making it change color. Thanks

-----Original Message-----
Mike
as an example:
=IF(TODAY()-A1>14,"CHECK","")then Conditional Formatting
to include something like [Cell Value is][equal to]
[="CHECK"]choose your colors.
HTH

in the [dialoque] boxes

-----Original Message-----
I am making a tracking data base and I would like to make
certain cells change color when a date in that row is
beyond a certain time frame. This will be used to
quickly identify overdue and upcoming events. Thanks in
advance.

Mike
.

.

 

[Peo Sjoblom]

You can use the conditional formatting without having a formula in the cell

Select the cell and in the conditional formatting select formula is and use

=TODAY()-A1>14

than you can enter the date in A1

--

Regards,

Peo Sjoblom

That helped out alot, but if I put a formula in a cell
then I can not have data in that cell, correct. And how
do I make the Conditional formatting to include a whole
row of date for making it change color. Thanks

-----Original Message-----
Mike
as an example:
=IF(TODAY()-A1>14,"CHECK","")then Conditional Formatting
to include something like [Cell Value is][equal to]
[="CHECK"]choose your colors.
HTH

in the [dialoque] boxes

-----Original Message-----
I am making a tracking data base and I would like to make
certain cells change color when a date in that row is
beyond a certain time frame. This will be used to
quickly identify overdue and upcoming events. Thanks in
advance.

Mike
.

.

 

[Mike]

I got great responses, but I do not understand the
formula thing. If I put a formula in a cell, then I can
not have data in it. What I want to do is have a date in
column 4. When that date goes over 30 days I want the
cells A4:H4 (one of many rows) to have the text all red.
Once a date in column 4 goes past 60 days I want the
cells in that row to be all blue. Where do I put the
formula and what do I put in the last box of conditional
formatting to make this all work??

 

[Peo Sjoblom]

Don't put the formula in the cell, when you do format>conditional
formatting, formula is there is a box where you can put the formula.

 

[Guest]

Have you tried conditional formatting?