See http://xldynamic.com/source/xld.CF.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"mckairborne" wrote in message
...
How can you use colors as a result in a formula, i.e. color a cell red
when
30 days from due date, color green when task accomplished.