View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kitfox
 
Posts: n/a
Default conditional format by comparing to current date

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