I would like to use the conditional format function to change the
background color of a cell. My spreadsheet contains the following
columns:
A)Today's Date B) Date of Last Visit C) Date of Next Visit

I want to set up an alert system in column C
- highlight the cell in column C yellow if it is two months or less
prior to today's date
- highlight the cell in column C red if it is past today's date
(over-due)

I have gotten confused on setting up the right equation using the
dates.

Thanks in advance for assistance.

1st condition: =A2C2 color: red
2nd condition: =month(C2)-month(A2)<=2 color: yellow

Regards,
Stefi

€žmary€� ezt Ã*rta:

I would like to use the conditional format function to change the
background color of a cell. My spreadsheet contains the following
columns:
A)Today's Date B) Date of Last Visit C) Date of Next Visit

I want to set up an alert system in column C
- highlight the cell in column C yellow if it is two months or less
prior to today's date
- highlight the cell in column C red if it is past today's date
(over-due)

I have gotten confused on setting up the right equation using the
dates.

Thanks in advance for assistance.