Making cells change color after a specified period of time.
 

Hi,

I'm looking for a way in excel to color cells on any dates that have
elpased more then 30 days. Can anyone help me with this.

Thanks for your help

Making cells change color after a specified period of time.
 

Use Conditional Formatting

Look Under Format, Conditional formatting


---
Message posted from http://www.ExcelForum.com/

Making cells change color after a specified period of time.
 

Marc,

You can use Conditional Formatting (CF) from the Format menu to
do this. Open the CF dialog, change "Cell Value Is" to "Formula
Is" and enter the following for the formula:

=(TODAY()-A1)30

Change A1 to the address of the cell containing the date.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Marc" wrote in message
...
Hi,

I'm looking for a way in excel to color cells on any dates that
have
elpased more then 30 days. Can anyone help me with this.

Thanks for your help

Making cells change color after a specified period of time.
 

Cells will have a date and we want to change the color on
those cells with anyhting past 30 days from those dates in
the cells
-----Original Message-----
Marc,

You can use Conditional Formatting (CF) from the Format
menu to
do this. Open the CF dialog, change "Cell Value Is"
to "Formula
Is" and enter the following for the formula:

=(TODAY()-A1)30

Change A1 to the address of the cell containing the date.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Marc" wrote in
message
...
Hi,

I'm looking for a way in excel to color cells on any
dates that
have
elpased more then 30 days. Can anyone help me with this.

Thanks for your help


.