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