vLookup, color as a value
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, color as a value
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.- |
vLookup, color as a value
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.- |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com