| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pulling data color using vlookup
I need to pull the text color over from my source file to destination file.
I'm using vlookup to pull the data and would like to pull the text color over also. I run a report each week and the colors may change. That is why I'm trying to use vlookup to pull the color over also. The command I'm using is: =IF(ISNA(VLOOKUP(A69,[Rates.xls]Sheet1!$C$3:$D$101,2,FALSE))=TRUE,"",VLOOKUP(A69,[Rates.xls]Sheet1!$C$3:$D$101,2,FALSE)) Is there anyway to incorporate pulling over what the data color is in the source file? Any help would be appreciated? Thanks -- Baltimore Ravens |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pulling data color using vlookup
See your other post.
Ravens Fan wrote: I need to pull the text color over from my source file to destination file. I'm using vlookup to pull the data and would like to pull the text color over also. I run a report each week and the colors may change. That is why I'm trying to use vlookup to pull the color over also. The command I'm using is: =IF(ISNA(VLOOKUP(A69,[Rates.xls]Sheet1!$C$3:$D$101,2,FALSE))=TRUE,"",VLOOKUP(A69,[Rates.xls]Sheet1!$C$3:$D$101,2,FALSE)) Is there anyway to incorporate pulling over what the data color is in the source file? Any help would be appreciated? Thanks -- Baltimore Ravens -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pulling data color using vlookup
Thanks,
The internet crashed on me and I thought it didn't go through -- Baltimore Ravens "Dave Peterson" wrote: See your other post. Ravens Fan wrote: I need to pull the text color over from my source file to destination file. I'm using vlookup to pull the data and would like to pull the text color over also. I run a report each week and the colors may change. That is why I'm trying to use vlookup to pull the color over also. The command I'm using is: =IF(ISNA(VLOOKUP(A69,[Rates.xls]Sheet1!$C$3:$D$101,2,FALSE))=TRUE,"",VLOOKUP(A69,[Rates.xls]Sheet1!$C$3:$D$101,2,FALSE)) Is there anyway to incorporate pulling over what the data color is in the source file? Any help would be appreciated? Thanks -- Baltimore Ravens -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pulling data from one sheet and listing selected data in another | Excel Worksheet Functions | |||
| Vlookup help on pulling more that one value. Any help is appreciated. thanks in advance | Excel Worksheet Functions | |||
| Vlookup while pulling a cell color and comment | Excel Worksheet Functions | |||
| Pulling data from web | Excel Discussion (Misc queries) | |||
| Pulling hair out with VLOOKUP | Excel Worksheet Functions | |||
Hybrid Mode
