Prev: vLookup, Look up Value
Next: How to avoid the pop up message for updating links?
From: Emece on 28 Mar 2010 19:01
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.-
From: JLatham on 28 Mar 2010 20:38
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.-
From: JB on 29 Mar 2010 04:49
With VBA

http://boisgontierjacques.free.fr/fichiers/Tableur/VlookUpColor.xls

JB
http://boisgontierjacques.free.fr/

On 29 mar, 01:01, Emece <Em...(a)discussions.microsoft.com> 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.-

 | 
Pages: 1
Prev: vLookup, Look up Value
Next: How to avoid the pop up message for updating links?