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