Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Lookup Function based on Font Color
Hello! I have several rows of data currently in which I would like to pull
data from. I could very easily use the LOOKUP function to do this. However, both the lookup range and vector range are all numbers. I only want the LOOKUP function to search for LOOKUP Values that are in a certain font color (red). To my knowledge, the LOOKUP Value can only be a number, text, logical value, or name or reference to a cell. Font Color is not one of my options. Does anyone have any ideas? Am I missing an easy step? Thanks for your time! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Lookup Function based on Font Color
I din't believe you can do that directly but with a workaround.
Put this function in a general module Function fontcolour(rng As Range) fontcolour = rng.Font.ColorIndex End Function In a column next to the lookup range enter the formula =IF(fontcolour(A1)=3,A1,"") This will extract all the red font values which you can use as the lookup range Mike "jstec68" wrote: Hello! I have several rows of data currently in which I would like to pull data from. I could very easily use the LOOKUP function to do this. However, both the lookup range and vector range are all numbers. I only want the LOOKUP function to search for LOOKUP Values that are in a certain font color (red). To my knowledge, the LOOKUP Value can only be a number, text, logical value, or name or reference to a cell. Font Color is not one of my options. Does anyone have any ideas? Am I missing an easy step? Thanks for your time! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
change font color based on a value | Excel Worksheet Functions | |||
I can't figure out how to add values based on font color. | Excel Discussion (Misc queries) | |||
Can I modify cell attributes (font,color etc.) based on function . | Excel Discussion (Misc queries) | |||
How do you change font color based on the value input? 1 = |
Excel Discussion (Misc queries) |