Here's what I am attempting to do...

On one worksheet, I have a date in the format MM/DD/YYYY.
On another worksheet, I have something similar to a Gantt chart where there is a row with day of the month, ex. 1, 2, 3, 4,... On this worksheet, in the row under the days of the month, I want to compare the day for applicable column to the date on the first worksheet and if it matches, I want to fill the cell with a color and cross-hatch. So, if my date on the first worksheet is 01/10/2013, then on the second worksheet, the cell under day "10" would be filled in. All others remain blank.

Appreciate anyone's help. Thanks.