VBA for Conditional Formatting of cells with different Month values

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.

Hello acsishere,

This is a 2 macro solution. A macro is added to the WorkSheet_Change event to identify when an entry has been made into either of the 2 columns. It then checks if the entry is a date. If it is a date then the second macro is called to color it by month.

Worksheet_Change() Event Code

Please Login or Register  to view this content.

Macro to Change Color and Format Font of Date

Please Login or Register  to view this content.

Geez, you go to sleep for 8 hours and some one answers the post.

Eh, this is better than my concontion.