Making cells change color after a specified period of time.

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
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
 
Highlight the column or cell you wish to change and use
the Conditional Formatting option. Good Luck!
 
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)

GerryK said:
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
.
Click to expand...
Click to expand...
 
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
.
Click to expand...
.
Click to expand...
 
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)

Mike said:
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
.
Click to expand...
.
Click to expand...
Click to expand...
 
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


Mike said:
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
.
Click to expand...
.
Click to expand...
Click to expand...
 
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??
 
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.
 
Back
Top