If you have a date in C10, for instance you can select that cell and
use

Format Conditional Formatting Condition 1 Formula is

=(C10<TODAY()+60)*(C10TODAY())

select desired formatting

The date will now be formatted accordingly if it's between today and 60
days time


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=508477