How to change Records Colors in every new month based on date using vba?

[sameh.abdelkawy]

Hi everyone!

I have long records entered in one year and I need to change the background color of records entered every month based on date entered. I need just 2 colors alternatively between months no more.
I need to do that on subform in the Form.
Thanks for any help.

 

[Gasman]

Divide the month by 2.
If int() of the result is equal result, use one colour, else use the other.

 

[sameh.abdelkawy]

Divide the month by 2.
If int() of the result is equal result, use one colour, else use the other.

Thanks for the quick reply but sorry I couldn't apply it. I need more details in example.
Your answer will be greatly appreciated.

 

[arnelgp]

open mainForm
close the form.
open sfBankActivity form in design view.
select all textbox.
on menu->format->conditional format, and see the formatting.

 

[sameh.abdelkawy]

open mainForm
close the form.
open sfBankActivity form in design view.
select all textbox.
on menu->format->conditional format, and see the formatting.

Hello,
That's what I need.
Thank you so much!!