vLookup, color as a value

E

Emece

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.-
 
J

JLatham

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
Student & Home? 1
Tracked changes by multiple people modified to one 0
Address Format changed after Migration 0
vLookup, Look up Value 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Match table shading (color) to Visio color/Transparency 1
Fill tringle in a cell with color 1

Top