highlight cells in a calendar with conditional formatting

I have made a calendar for the month with each day in a different cell, using 7 columns of cells for days of the week and 5 rows for weeks of the month... simple. The first column is Sunday, etc. Lets say that represents January.

In another tab I have a range of cells that I want to put dates on.

Can I use conditional formatting to highlight each cell if its corresponding date exists in that list of dates?

I was thinking of applying conditional formatting to the whole month.

I was thinking about extracting the month and day out of each date and putting them next to the date. Then test if the month = 1, and then if the day matches the corresponding cell in the calendar, highlight it.

Can all that be done with conditional formatting? And if it can, what would the formula look like? I cant seem to come up with something that works.

I am attaching a sample spreadsheet. Any help would be greatly appreciated.

Eddie

See if this is what you mean.

Thank you WHER. You are the man!

That is exactly what I needed! I will then add additional rules for each additional month.

Eddie

One last thing.... how do you edit the complete formatting rule? It is a bit lengthy so I have to scroll through it to see it all but when I use the arrows to scroll through it, it places cell positions instead.

Eddie

Man, you guys are very knowledgeable! Thank you Palmetto!

You guys are so quick also! Awesome!

Eddie