Copy cells value and formating based on conditions

[kipulbiu]

Hi,

How could I write the following excel line of code in VBA and add conditional formatting (interior and font).
=IF(AND(OR(F19="1ere",F19="2me",F19="7me"),OR(M19=2,M19=6, M19=9,M19=11)),G19,"neant")

I have a range of columns from (B3:AJ3)

Thanks in advance for your precious help

Bruno