I cannot get the conditional formatting to paste to a new workbook when i use the Pastespecial Paste xlFormats function. I am copying the current selected row of data (Range C-Y) from the production schedule file and pasting it into the next empty row in the results file. The problem is the conditional formatting will not transfer over to the new row, and becasue i need the other formatting to come over, i cannot just put the conditional formatting into the results file and paste values only. Does anyone know how to get the conditional formatting to transfer with all of the other formatting?Master Production Schedule.3.26.13.xlsmMaster PS Results 2013.xlsx
Bookmarks