Formatting - vlookup?

DGuy92034

New Member
Joined
Sep 10, 2014
Messages
5
Is there a way to pull the formatting (Cell Color)" from the original data sheet

I am working off 2 sheets in excel..


Sheet1 (Database) contains all my data, with colored cells


Sheet2 has my VLookup formula - =VLOOKUP(D7,Database!D:P,4,1)


Is there a way to bring the color of the cell over using my formula?
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Watch MrExcel Video

Forum statistics

Threads
1,108,500
Messages
5,523,288
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top