Fill color by date

  • Thread starter Thread starter Intellphantom
  • Start date Start date
I

Intellphantom

I'm working with Exel 2007. I made a simple spreadsheet with several due
dates of a particular project. The spreadsheet shows when a person first came
onto the company, and I need to track when their evaluations are due. The
first is due 30 days after, 10 months after and a year after the initial hire
date. I'd like to be able to turn the cell yellow two weeks before the review
date, and red on or after the due date. I'm somewhat familiar with Excel, but
it's been several years since I've had to write formulas. Thank you for your
time!!
 
Wendy,

I sent both the workbook and another message with no attachment. Let me know if you receive either.

HTH,
Bernie
MS Excel MVP
 
Back
Top