Calendar with links to sheets in a workbook

I have set up a calendar with drop down list for the month and year. What I want to do is a logical formula that uses data from another worksheet to give a true of false if the date in the that other sheet matches the date in the working sheet. In other words if cell X is 2/2/15 and is equal to cell y on the calendar sheet, it returns a value (green colored cell). If false, it is a white colored cell.

See the sample calendar Sheet6. On one sheet (2) is the start and end date for individuals. I want to be able to drop down dates on the sheet6 calendar and have the corresponding names show up on the sheet at the appropriate dates. So Mike will have a green box on 2/17/15,2/17/2016, and 2/17/17. All the other boxes will be white in reference to Mike. I want to use only start dates for each individual.

http://www.excelforum.com/excel-form...ated-data.html


The above post is similar to what I am attempting to do. I would like to compare start up dates for each individual from year to year.