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)



"tbird333" wrote in message
...
i am making a spreadsheet to track training. I put in completed dates and
when they come within 90 days of being due i want the cell to turn orange,
and when they are within or past 30 days turn red. the rest of the time i
want them all green.