I have created a spreadsheet of various dates of when my employees annual
trainings are due. I would like the cell color to change based on how many
days to their training is due. If the renewal date is more than 60 days away
I would like the cell one color, if the renewal date is 60 days to the date
it is due, the cell would be a different color if the renewal date is past
due it would be a third color. The cells are in m/dd/yy format.

Thank you.

Have a look at this link.
http://office.microsoft.com/en-us/he...655491033.aspx


--
Just a fellow Excel user here to help when I can.....


"ckane" wrote:

I have created a spreadsheet of various dates of when my employees annual
trainings are due. I would like the cell color to change based on how many
days to their training is due. If the renewal date is more than 60 days away
I would like the cell one color, if the renewal date is 60 days to the date
it is due, the cell would be a different color if the renewal date is past
due it would be a third color. The cells are in m/dd/yy format.

Thank you.

See http://www.xldynamic.com/source/xld.CF.html#due

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"ckane" wrote in message
...
I have created a spreadsheet of various dates of when my employees annual
trainings are due. I would like the cell color to change based on how
many
days to their training is due. If the renewal date is more than 60 days
away
I would like the cell one color, if the renewal date is 60 days to the
date
it is due, the cell would be a different color if the renewal date is past
due it would be a third color. The cells are in m/dd/yy format.

Thank you.