Conditional Format
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.
|