Ike Hunter
New Member
- Joined
- Dec 15, 2011
- Messages
- 35
Hi,
Looking for vba to alert me when a date is 4 days old and there is not a date in an another cell of the same row.
VBA runs when I open the workbook.
Column AC can be blank or have a date. Ignore all when cell in Col AC is blank
Column AE can be blank or have a date. Ignore all when cell in Col AE has a date
If row in Col AC has a date and that date is now 4 days old and same row in Col AE is blank
Then go to that cell(s), format cell red
And a msgbox alerting which cell(s) in Col AE needs attention.
Could be several rows with this issue.
Thank you in advance.
Looking for vba to alert me when a date is 4 days old and there is not a date in an another cell of the same row.
VBA runs when I open the workbook.
Column AC can be blank or have a date. Ignore all when cell in Col AC is blank
Column AE can be blank or have a date. Ignore all when cell in Col AE has a date
If row in Col AC has a date and that date is now 4 days old and same row in Col AE is blank
Then go to that cell(s), format cell red
And a msgbox alerting which cell(s) in Col AE needs attention.
Could be several rows with this issue.
Thank you in advance.