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)
"Ralph" wrote in message
...
Hi:
I have a large spreadsheet that I track employee training on. The cells
contain the DUE date of next training I would like to format it so that
if a
training date is past the DUE date the cell color is "red". If the date
is
within 0-30 days the cell is "amber", and if it is within 31-60 days of
DUE
date then "yellow".
Many thanks for you help....