Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup and cell shading
I am pulling in data using a Vlookup and would like for it to keep the same
cell color shading as in the original spreadsheet that it is pulling from. Is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup and cell shading
No, a formula can not be used to convey formatting information, only values.
If the cell shading is applied through conditional formatting, though, the same conditional formatting could be applied to the cell with the VLOOKUP formula in, to achieve the same effect. Pete "Sherry" wrote in message ... I am pulling in data using a Vlookup and would like for it to keep the same cell color shading as in the original spreadsheet that it is pulling from. Is this possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup and cell shading
Yes! But you would need to use VBA. You first need to identify the address
of the cell with the value that was chosen, and then use VBA to return the format of this cell and then apply that format to the new cell. To do the first bit you could add a column which holds the row number, you know the column letter and you can now make a reference to the cell. Hope this helps, if not happy to go into more detail. MVK "Sherry" wrote in message ... I am pulling in data using a Vlookup and would like for it to keep the same cell color shading as in the original spreadsheet that it is pulling from. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is it possible to sort the data by cell shading or cell color? | Excel Discussion (Misc queries) | |||
Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
shading a rowwhen a time is entered but no shading when 0 is enter | Excel Worksheet Functions | |||
Vlookup Function Cell shading | Excel Discussion (Misc queries) | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) |