I want to specify a text color as the look up value in the vLookup Formula.
Is this possible? Do I need the code of the color?

Thanks in advance

Regards,
Emece.-

VLOOKUP() knows absolutely nothing about any colors, it works on values only.

You can get some information that may help you from Chip Pearson's site
http://www.cpearson.com/Excel/colors.aspx

You're probably going to have to use VBA code (macro) to find an entry based
on font color. And yes, you'll need the color code. You can get that by
recording a macro while setting any cell's font color to the color you'll be
looking for and then examining the code recorded.

"Emece" wrote:

I want to specify a text color as the look up value in the vLookup Formula.
Is this possible? Do I need the code of the color?

Thanks in advance

Regards,
Emece.-

With VBA

http://boisgontierjacques.free.fr/fi...ookUpColor.xls

JB
http://boisgontierjacques.free.fr/

On 29 mar, 01:01, Emece wrote:
I want to specify a text color as the look up value in the vLookup Formula.
Is this possible? Do I need the code of the color?

Thanks in advance

Regards,
Emece.-