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
 
Use Conditional Formatting

Look Under Format, Conditional formatting
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Making cells change color after a specified period of time. 3
Change cell color based on date 8
Tabname function 1
Change Format of Active Cell 15
COlor Coding specified time frames 1
color cells of period 1
interior colored cells counting 3

Back
Top