Cell Fill Color

[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.

 

[Franz Verga]

Nel post *[email protected]* ha scritto:

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.

I assume you have your dates starting from row 2, so select F2 and, using
Conditional Formatting (menu Format, Conditional Formatting), apply this
conditions:

Condition 1: Formula Is, =($F2-$C2)<0 Format Pattern Red

Condition 2: Formula Is, =INT(($F2-$C2)/2)<31 Format Pattern Yellow

Now you can copy your conditional format from F2 down to all the cell you
need.

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy