VBA for Conditional Formatting of cells with different Month values

[acsishere]

Dear Friends,

I have two date columns, say E & F.

In these two columns I have entered date values. I need to do colour, font bold, Italic automatically when date values are entered in these columns - with a conditional formatting - i.e. every month should be in different color.

For example, values 23/05/2009, 15/10/2005, 07/12/2004 must be automatically coloured with different colors as its months are different.

Can any one please help me to solve this problem.

Thanking you,

acsishere.