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?
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?