Excel 2010 - If statement to pull through Start and End Dates of a Project

I have a workbook that contains multiple sheets. The first sheet contains start and end dates of a project. On the 2nd sheet I have columns Jan to Dec. I need to create a formula that looks at both the start and end date in Sheet 1, and then puts the corresponding date into the correct month column in Sheet 2. ie. If the start date was 24/02/12 it would put that date in the Feb column. If the End date was 15/03/12 that date would then pull through to the March column in sheet 2.

I am then hoping to set up a conditional format that places a green dot on the start date, and a red one for the end date so at a glance I can see my project anticipated start and end.

Any help you can give wold be much appreciated.

I have had a go at the start bit, but cannot get my head around how to do both Start and End.

I have attached a dummy sheet which should help.....

Many thanks

test.xlsx

See attached.

First I named the Projects Summary sheet, column C:L as Projects mostly because when using conditional formatting, you can't refer to a range on another sheet directly, but can if you name the range....

So formula in E8 of Project Scheduling sheet is:

Please Login or Register  to view this content.

copied down and across the table.

Then select the E8 to P510 (or whatever the bottom is) and go to Home|Conditional Formatting|New Rule.

Select use a formula to determine which cells to format and enter formula:

Please Login or Register  to view this content.

click Format and choose green from the Fill tab.

Click OK... then click New Rule and repeat with formula:

Please Login or Register  to view this content.

and pick Red.

You can use another colour to indicate equality... with formula:

=AND(MONTH(VLOOKUP($C8,Projects,9,0)),MONTH(VLOOKUP($C8,Projects,10,0)))=MONTH(E$6)

make sure to set this at the top of the conditional list and check stop if True