M
marypulliam
I am using Excel to track customer visits. Based on conditions, I am
alerted when follow-up visits are nearing & due by changing the font
color to yellow (two-months before due date) and red (past due date).
The font color is changing in column E. I would like to change the
fill color of the corresponding cell in column F (next visit due date):
yellow - two months prior to due date; red - due date has passed. I
couldn't figure out how to change the fill color in column F based on
the results in column E. Is this possible? Thanks in advance for
assistance with VBA script to accomplish this task.
The columns are set up as follows:
a) Customer Name b) Date of Initial Visit C) Today's Date D)
# of Months Before Next Follow-up E) Months Since Initial Visit F)
Future Visit Date
Highlighting the entire row as an alert would also be acceptable.
Again, thanks for any help.
alerted when follow-up visits are nearing & due by changing the font
color to yellow (two-months before due date) and red (past due date).
The font color is changing in column E. I would like to change the
fill color of the corresponding cell in column F (next visit due date):
yellow - two months prior to due date; red - due date has passed. I
couldn't figure out how to change the fill color in column F based on
the results in column E. Is this possible? Thanks in advance for
assistance with VBA script to accomplish this task.
The columns are set up as follows:
a) Customer Name b) Date of Initial Visit C) Today's Date D)
# of Months Before Next Follow-up E) Months Since Initial Visit F)
Future Visit Date
Highlighting the entire row as an alert would also be acceptable.
Again, thanks for any help.