Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup and bring the "font color" of the cell across?
During vlookup ------ How do I bring the "font color" across with the data?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup and bring the "font color" of the cell across?
If that font colour has been set by means of conditional formatting,
then you can apply the same CF rules to the cell containing VLOOKUP. However, if you have set the colour manually, you will not be able to bring that back to the cell with the formula in, as a formula can only return a value, not a font. Hope this helps. Pete On Aug 17, 2:01*pm, ernie.recob wrote: During vlookup ------ How do I bring the "font color" across with the data? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using function based on "Font Color" | New Users to Excel | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Different Font Color for results evaluated by "IF" | New Users to Excel | |||
Bring cell colour as well as number along with the "Max" function | Excel Discussion (Misc queries) | |||
Any IF(A2=font color=red", "1", "0") in excel? Or a way to do it? | Excel Discussion (Misc queries) |