Forum Discussion
Joel_Ser
Nov 20, 2019Copper Contributor
Look up data and keep cell color
Hi there, I'm trying to look up both the cell data and background color between 2 workbooks. I understand the vlookup function does not allow me to do this and it may only be viable through VBA, but ...
Smitty Smith
Nov 25, 2019Former Employee
Joel_Ser See if this helps:
https://stackoverflow.com/questions/22151426/vlookup-to-copy-color-of-a-cell-excel-vba