Conditional Formatting cells with dates

  • Thread starter Thread starter MsButterfly
  • Start date Start date
M

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?
 
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?
Click to expand...

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.
 
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?
Click to expand...

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.
 
Back
Top