Vlookup retrieve cell data and conditional formatting

**Philly123** · 06-24-2012, 06:53 PM

Hi, I have two two excel files and I would like to figure out a way to have a vlookup (or something similar) pull both the data in the cell and the conditional formatting from one file to the other. Is there a macro that would do this for me?

Thanks

**FDibbins** · 06-24-2012, 07:26 PM

vlookup into another file works the same way as for another sheet (or the same sheet), so you just open both files, and build the vlookup that way.

for the CF, you cant exactly "pull" the CF in without VB, but what you could do is apply (up front) the same CF to the cell where the answer will go

does this help at all?

**Philly123** · 06-24-2012, 11:14 PM

Thanks for the reply FDibbins. Do you know a way in VB to get the conditional formatting to be pulled from the first sheet into the second sheet? To give you more details, the file I am working with has many different sections (one section for each type of mutual fund). I want the cells to be green for the funds that beat the benchmark for that section and red if they underperform the benchmark. I have 20+ sections all with different benchmarks so it would be very time consuming to manually do the conditional formatting for each section each month when the new data comes in. My raw data is in excel (with the cells already conditionally formatted in red or green) and comes from a software program called Morningstar Direct.

Would it be easier to do VB code that would bring over just the cell color instead of the conditional formatting?

Thanks!