Making cells change color after a specified period of time.

  • Thread starter Thread starter Marc
  • Start date Start date
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
 
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
 
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
 
Back
Top