Hey everyone,
I think this may be possible to do in Excel, but not sure. For you Excel gurus out there, here's the challenge:
On the main sheet of a workbook, there is a list of contacts (in column A, cells A2 onwards. A1 is the heading of the column titled "Contacts"). In columns B onwards, there are various titles such as "phone number", "address", etc.
Each contact has all of their info listed in a single row (For example, Billy J. takes up Row 2, Frank D. takes up Row 3 and so on). Sometimes their information needs to be updated, such as their address. This is simple to do, but here's the difficult part:
It's important to know how old each piece of data on the Main Sheet is. For example. if their phone number has been updated within the last 30 days, the text (or something similar) needs to be displayed as green, if it has been updated over 30 days ago but within 90 days, the text needs to be displayed as yellow, and anything that hasn't been updated within the past 90 days, the text needs to be displayed as red. Each cell needs to be green, yellow, or red, based upon when it was updated, independent of when other cells were updated.
You may use additional sheets that store data such as time/date stamps, calculations in regards to the date, etc. You may use conditional formatting such as Icon Sets if they apply. You may write VBA code.
This is my challenge to you guys, please let me know if you have any questions / need clarification.
I think this may be possible to do in Excel, but not sure. For you Excel gurus out there, here's the challenge:
On the main sheet of a workbook, there is a list of contacts (in column A, cells A2 onwards. A1 is the heading of the column titled "Contacts"). In columns B onwards, there are various titles such as "phone number", "address", etc.
Each contact has all of their info listed in a single row (For example, Billy J. takes up Row 2, Frank D. takes up Row 3 and so on). Sometimes their information needs to be updated, such as their address. This is simple to do, but here's the difficult part:
It's important to know how old each piece of data on the Main Sheet is. For example. if their phone number has been updated within the last 30 days, the text (or something similar) needs to be displayed as green, if it has been updated over 30 days ago but within 90 days, the text needs to be displayed as yellow, and anything that hasn't been updated within the past 90 days, the text needs to be displayed as red. Each cell needs to be green, yellow, or red, based upon when it was updated, independent of when other cells were updated.
You may use additional sheets that store data such as time/date stamps, calculations in regards to the date, etc. You may use conditional formatting such as Icon Sets if they apply. You may write VBA code.
This is my challenge to you guys, please let me know if you have any questions / need clarification.