Making cells change color after a specified period of time.

M

Marc

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
 
C

Chip Pearson

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
 
M

Marc

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
 
Top