You are here:

Excel/Excel auto updating of time sensitive info


File will be for tracking projects.
Projects are time sensitive.
The idea is, each Row would be a project with the project info.
As time passes, certain lines (determined by the project length in days which would be one of the columns) would change their look.
Font's turn Bold, then perhaps turn a different color (denoting the due date getting closer), then even the row might change color denoting the projects due date being very close or even due.
Lets say, if this were for tracking School Projects. There would be the initial info filled into the row. There would be a Start Date Cell and an End Date Cell. A Cell that tracks how many days left. So, once the cells are filled in for each project. The idea is, Rows will change their VISUAL look to show when something is getting close to being due according to the length of time for the project. Some projects might only be a week long, yet others might  have months to complete. So the changes will be on a Row by Row basis.
Additionally, more projects will be added as time goes on.
Again, if this were to track School Projects and such. Then as new projects are assigned, they are input in and the file AUTOMATICALLY shows identifiers as to what is close to being due.
A self updating visual time line you might say. With colors and font changes to help show what where things are in correlation to their due dates.

I hope this all made sense.


Read up on Excel's Conditional Formatting feature.  That let's you change the physical appearance (formatting) of a cell based on a formulaic test you create.  The most common is date tests.

If you have a Due date listed in cell A1, then a CF in B1 could change the color of B1 as the date in A1 draws nearer.  

For instance:   =A1-TODAY()<=7

with that formula when today's date is a week from the due date, the formula triggers as TRUE, so whatever formatting you attach to that test wout trigger.

You can set up multiple CF test in on a cell/column/range:

=A1-TODAY()<=7   (red)
=A1-TODAY()<=14  (yellow)
=A1-TODAY()>14   (green)
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here


All Answers

Answers by Expert:

Ask Experts


Jerry Beaucaire


Excel Formulas, macros, automation. Microsoft Excel MVP - 2010. Code site with free code snippets and techniques:


Microsoft Excel MVP - 2010. I have my own extensive Excel help/code site: ===================== I have been offering free assistance as an Excel aid on many web sites for many years: ( - JBeaucaire) ======== ( - JBeaucaire) ======= ( - jbeaucaire)

Bachelor's Degree from Azusa Pacific University in Mathematics and Music Composition

Awards and Honors
Microsoft Excel MVP 2010

©2016 All rights reserved.