Vlookup with front color together

**Lasting** · 05-02-2011, 11:19 PM

Dear all,

Could anyone kindly help to offer the solution of how to vlookup with font color together from the soucing excel not just value?

I search by google and get a VBA solution like this:

Please Login or Register  to view this content.

But seems it didn't work in my case. Can anyone kindly help?

Btw, I am new to VBA, Detail explanation will be highly appreciated, thanks a lot in advance!

**teylyn** · 05-02-2011, 11:46 PM

Hello,

Please use code tags when posting code. I've added them for you this time.

What does not work? I don't understand completely what you want to achieve. Look up colors? Please post a sample file and explain in context.

**Lasting** · 05-03-2011, 03:17 AM

Thx for ur help and sorry for not note that need to use quote tags as a new comer.

My situation is:

I have two excel files - A.xls & B.xls. The column B2:E20 of A.xls are values that vlookup from B.xls and the fomular is

=vlookup(A;A,'Y:\Testing\Procurement\[B.xls]Sheet1'!$A:$E,5,FALSE)

As u can see, vlookup can only have the value back but not the font colors of original data together the same time. But I need to know the font color on some cells of A.xls, once B.xls change the font color of column E, eg. from Red to Blue.

Is it clear? Or I need to upload the two excels for asking help? Thx in Adv anyway~~~

**royUK** · 05-03-2011, 04:48 AM

That Function doesn't look like it returns a colour.
It doesn't specify a different workbook so if it worked it would not be checking a different workbook.
Also a Function cannot affect a cell's formatting

**Lasting** · 05-03-2011, 05:17 AM

oh, thanks for your kindly reply. And is there any other way to make vlookup get the value with font color of cell by using VBA?

**royUK** · 05-03-2011, 05:44 AM

As Teylyn sid - please post a sample file

**Lasting** · 05-04-2011, 02:43 AM

Enclosed please find Order2011.xls & Sales2011.xls
Two columns "date" & "customer" of Order2011.xls are vlookup from Sales2011.xls.

But the value got through Vlookup can display in black only.
I hope Order2011.xls can see the value with the font color(in pink & blue) the same as the cells on sales2011.

Is there any way can achieve that? Thx a lot in adv~~~