Copy cells value and formating based on conditions

kipulbiu

New Member
Joined
Aug 14, 2016
Messages
36
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
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Watch MrExcel Video

Forum statistics

Threads
1,109,070
Messages
5,526,609
Members
409,712
Latest member
lager2020

This Week's Hot Topics

Top