Greg,
Thanks that worked.
"greg7468" wrote:
Roy,
It returns a value of false because it is outside the +25 days from
today rule you have set.
I assume you are only really interested when the cell changes to yellow
then red, whilst it's green it doesn't matter how many days away the due
date is.
If this is the case why not just change the formula to
=IF(F2<=TODAY(),"RED",IF(F2<=TODAY()+5,"YELLOW","G REEN"))
This will be green for anything over 5 days away from today.
If this does not work for you, what do you want it to return if the due
date is 30 days away from today.
HTH
Greg.
--
greg7468
------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=373867
|