Conditional Formatting
 

Excel Problem

I have a problem as far as conditional formatting is
concerned.

Problem

I have a spreadsheet called (Report Dates) that stores
dates, it is split into 12 worksheets each corresponding
to a month. In that you enter a date of when a report is
sent in. for example (01/12/2003)

Now I have another spreadsheet that is called (Exception
reporting) with two columns one says Received the other
says Not Received.

What I would like to happen is as soon as a date is
entered the in (Report Dates) I want the corresponding
month in Exception reporting to read Received in Green. If
however it is not received then I want it o read Not
Received in Red.

So If the correct date is entered I want the to say
Received if not then I want it I sat Not received

I hope that all this makes great sense

I hope you can help

Thanks in advance

Joel