Changing text/color after a time period?

  • Thread starter Thread starter metalsped
  • Start date Start date
M

metalsped

I hope some of the brilliant Excel people here can help me out. What I
am looking to do, is enter a date in a certain cell (if it helps
conceptualize, the date that I ship something to someone). Is it
possible to have that cell with the "ship date" in it, either change
colors, or change the font size, or something, after 30 days have gone
by? My reasoning is that the product I ship out, has to be back to me
in 30 days, or a penalty will incur to the other party. I just want
these fields that have exceeded the 30 day mark, to stick out, so I can
easily identify them. Thanks for any help in advance!

Rich
 
Awesome! Once again, someone comes through for me. Thanks a lot Anne
 
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

Comparing Dates 4
Trailing 30 days sum calculation with excel 1
Conditional formatting 1
Grouping period of date 6
Change Color of cell 3
How do a set the current date to change in cell everyday 1
Multiple conditions 2
Clearing a cell value after a set time period - Macro?? 3

Back
Top