conditional formatting

[ckane]

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.

 

[Red]

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

 

[Bob Phillips]

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)