Conditional Formatting cells with dates

[MsButterfly]

I have created an attendance tracking spreadsheet and would like to have the
cells containing hire dates to change colors on each employee's anniversary
date. How do I do this? What formula can I use?

 

[ed]

I have created an attendance tracking spreadsheet and would like to have the
cells containing hire dates to change colors on each employee's anniversary
date.  How do I do this?  What formula can I use?

Assuming hire dates are in column Cstarting at row 3, put Conditionnal
Formatting formula in C-3 First condition =today()-c3>1095.
Second condition =today()-c3>730 Third condition =today()-
c3>365. Assign a different color to Font for each condition.
Sorry only 3 conditions available.
ed.

 

[ed]

I have created an attendance tracking spreadsheet and would like to have the
cells containing hire dates to change colors on each employee's anniversary
date.  How do I do this?  What formula can I use?

Assuming hire dates are in column C, starting at row 3, put
Conditionnal
Formatting formula in C-3 The formula for the first condition is
=today()-C3>1095. The formula for the second condition is =today()-
C3>730 The formula for the third condition is =today()-C3>365.
Assign a different color to Font for each condition. Copy the
conditional Format of cell C3 down to end of your list with your
Formula Brush.
Sorry only 3 conditions available.
ed.