Jul 11, 2009 #1 kendas Technical User Joined Feb 2, 2004 Messages 108 Location SG anyone have a vba code to highlight tasks that has been overdued for 1 week in RED ?