Vba macro code for differentiation using colors

Hello every one!!!

I need macros in such a way that, to differentiate between different set of dates with some color.

even for the headings in different color to identify in between.

I have done manually in the attached excel sheet for your kind reference and easy understanding.

thank you...

Regards,
Dharani.

Here is CF for left set of data

(if dates always alternate, odd/even)

Like this:
1.1.
2.1
3.1.
4.1.

Not like this:
1.1.
3.1.
4.1.
6.1.

Originally Posted by zbor

Here is CF for left set of data

(if dates always alternate, odd/even)

Not like this:
1.1.
3.1.
4.1.
6.1.

wow. this is simple and best method... thanks a lot.... great...

but when i apply like =MOD(B2,2) it is giving the output as 01/00/1900
then if i copy and paste your cell in my cells then it is giving as 0's and 1's but if i directly write =mod(b2, 2), it is giving as 01/00/1900 rather giving as 0 and 1.
(even in your attached file, the first cell is like this only)
what shall i do???

Thank you...

Regards,
Dharani.

Format it as general not as date (that excel will do automatically in this case).

Oh, sorry, now I see what yo uasking for.
Delete that column. Don't need it. It was just for test.

Originally Posted by zbor

format it as general not as date (that excel will do automatically in this case).

Oh, sorry, now i see what yo uasking for.
Delete that column. Don't need it. It was just for test.

thank you so much for spending your valuable time in helping me...
Thanks a lot...

With kind regards,
dharani.