Jan 19 2019 05:50 PM
When I am using VLOOKUP, I want the background color of H4 to be set to yellow by VLOOKUP as well, in other words, I want VLOOKUP to copy both words and their formats.
I know VBA may help me to realize it, but it cannot be transferred across different books as easily as internal formulas. Is there a better way to do this?
Jan 20 2019 04:24 AM