| 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! |
| 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) | |||
Threaded Mode
