Try Conditional formatting.

But this forumla as the first condition

=IF($A1TODAY(),TRUE,FALSE) To see if date as happened

Format to original

then this one

=IF($A1-TODAY()-14<=15,TRUE,FALSE) to get your 15 day rule

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=563137