Conditional Formatting cells with dates


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?
 
Ad

Advertisements

E

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

Advertisements

E

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top