Hi Excel gurus,
Does anybody know, how to add for example 70 days to date in cell and
then use it in condition ?
I have column with date in every cell. I need the date go to red color,
when I add to date 70 days and the date go over specific date.
Example - I have some date : 1.1.2005, now, if I add 70 days and the
datum go over specific date, for example 1.2.2005, change color to
red.
I don't know, how to add days to date, and I don't know, how exactly
build up a condition.
Thanks in advance
Satucha
--
satucha
------------------------------------------------------------------------
satucha's Profile:
http://www.excelforum.com/member.php...o&userid=26621
View this thread:
http://www.excelforum.com/showthread...hreadid=488092