I need to copy color from my source file to a destination file. I prefer to
use vlookup if possible. I pull a report every week and I need to capture the
color of the text.

The code I'm using to pull the data 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 a way to pull the color of the data over also?

Any help would be appreciated

--
Baltimore Ravens