How to transfer Formatting to another Excel worksheet?

I have a workbook in which Sheet 3 & Sheet 4 have formulas that reference Sheet 1 and Sheet 2. I need to find out how to get the formatting (most importantly, background color) of the original cells on Sheet 1 and Sheet 2 to transfer to the cell that references it on Sheet 3 and Sheet 4. The formulas use a vlookup based on dates, and therefore change regularly. I believe it requires VBA. I can usually manipulate code to produce the desired results, but do not know where to start for this.

Sample info:
Formula in Sheet 3 $H$8 =IF(VLOOKUP(‘Sheet 1′!$F$12,’Sheet 1’!$A:$CZ,6,FALSE)=0,””,(VLOOKUP(‘Sheet 1′!$F$12,’Sheet 1’!$A:$CZ,6,FALSE)))

Sheet 1 $F$12 contains a date (produced by a formula) that is used for the vlookup.

Explorer Asked on 22nd June 2015 in Excel for Windows.
Add Comment
  • 1 Answer(s)

    You can know how to format the sheets and then transfer it to one page to another. By clicking this evaluation academized reviews you will be able to learn all the specific traits that are giving much ways to consult.

    Explorer Answered 2 days ago.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of use.