Thanks, Steve. It did help, but for some reason, one of the cells turned red
and it is dated 7/18/06, so it should be green. Should I change my cell
format? It is currently set to "NumberDate*3/14/2001". Thanks again for
the help.
Chris
"SteveG" wrote:
Chris,
Try this.
Instead of Cell Value is, use the Formula Is option.
Condition 1
=A17<=TODAY() then Red
Condition 2
=A17<=TODAY()+14 then Yellow
Condition 3
=A17TODAY()+14 then Green
Cheers,
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=491626