Excel help please

[MikeHunt79]

I'm trying to compare months from dates in a spreadsheet, and blank out a column if it is a different month to other columns.

Is there a way to do this with Conditional Formatting?

 

[MikeHunt79]

Cheers for the help, I think I've figured out what the problem is... For some reason Excel assumes every month has 31 days, is there any was of getting around this with some formula's or code?

 

[MikeHunt79]

Well, I sort of gave up in the end and just formatted them by hand... Cheers for the help tho, Excel can be amazing at times but frustrating at others...