Macro to act differently on selected Multiple Columns

**xlbiznes** · 01-19-2014, 08:52 AM

@e4excel ,

the file that you have posted is not very informative, please replace the data with non relevant data and make it more clear for the forum members to understand your needs.

The green area that you are referring to has emp_no and name, so what needs to be done

Seriously you need to make another proper file to make things more clearer.

**e4excel** · 01-19-2014, 11:02 AM

Dear xlbzines...

What I intend to do?

I will be entering new employee nos in the sheet SP List in Column B as plain General Nos.. This is the list of certified employees whose information is fetched from 2 separate files Emp_Retail and Emp_Premier...

IF(ISNA(VLOOKUP($B4,$A$13:$C$17,2,0)),VLOOKUP($B4,$A$20:$C$23,2,0),VLOOKUP($B4,$A$13:$C$17,2,0))

Now after I run the formula I would be selecting the entire data from lets say...B4:S7 coloured in yellow in which I need to have the exact same formatting as the one in the above two rows...

I know how to do it for a single column, but do now know how that can be done on Multiple Column Selection..so that the Formatting Macro makes the contents in the col B Emp Nos as text and then the remaining columns get their Formatting differently..

Regards
e4excel