date update query

hs0kbl

New Member
Joined
Sep 19, 2006
Messages
2
Hi Please help. I want to create a spreadsheet that can update on opening workbook. I also wish to be able to flag information in the spreadsheet so that from the date of data entry I will be able to tell if an action (eg. person contacted) hasnt taken place before a two week time period. For example, after data input the cell turns yellow if a date is nearing (eg. 12 days after data input) and then turns red after 14 days (if the action required hasnt been noted in the spreadsheet, that is, no action has been taken). If action has been taken then the cell turns green.

Can you help? I am sure there must be a way of doing this. I hope I have explained myself clearly enough. I look forward to any replies to my query.
Thank you in advance.
Karen
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
59,025
Office Version
  1. 365
Platform
  1. Windows
Welcome to the board, Karen.

If you want a file that updates automatically upon opening, you probably may need VBA, specifically, Event Procedures which are macros that run automatically when some event happens (like opening a file). You can find a write-up on them at: http://www.cpearson.com/excel/events.htm

As far as changing colors based on values/dates, you may be able to accomplish a lot of what you need with Conditional Formatting. I would recommend checking out "Add, change, or remove conditional formats" in Excel help, and posting back if you still have specific questions or find it doesn't do what you want.
 

hs0kbl

New Member
Joined
Sep 19, 2006
Messages
2
Date Update Query

Just to say a big thanks for such a speedy reply.

Is there any way of just using 'refresh' on the NOW() function to do this?

Karen
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
59,025
Office Version
  1. 365
Platform
  1. Windows
Why do you need to do a refresh of the NOW() function?

The NOW() function is dynamic itself, so there shouldn't be any need to refresh it (as long as you have automatic calculation turned on for your spreadsheet).
 

Forum statistics

Threads
1,141,416
Messages
5,706,310
Members
421,441
Latest member
VapesRub

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top