I am trying to get code to apply a red fill in cells in columns B:C until last cell when the date < Today & Columns D until last cell if the column does not contain an "@" symbol, I am working with excel 2003 and cannot have numerous conditional formats so I need VBA to do it, Can anyone point me in the right direction?