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

vLookup, Look up Value 1
Replace #N/A with 0 1
Conditional Formatting Excel 2007 2
Conditional Formatting based in cell color 2
Excel 2007 - change size of text as a result of conditional format 4
Excel Trying to do a vlookup with a nested right function on the array 3
Vlookup and what else? 2
Change background color of cell based on vlookup in cell 1

Top