We will be importing an Excel spreadsheet, which will contain a simple list of Projects being run and will contain the following information: Project ID, Name, Project type, Project owner name, Current status, and then subsequent dates for various tasks to be completed for that project.

What I want is to colour code the dates based on a traffic light system, and set up a rule to enable SharePoint to send a report of programs that contain RED and AMBER dates (i.e. those requiring action etc) on a weekly basis.

Can this be set up within Sharepoint Alerts? And can more that one Alert be set up? (i.e. also a monthly report of outstanding RED, AMBERS, and a monthly report of GREEN completed tasks).

Preferrably without any coding being deployed please.

Many thanks!