Forum Discussion
Conditional Formating copy VBA
Formatting (including conditional formatting) can be copied/pasted regardless of whether a cell contains a value (or formula) or not...
could you give an example of the code
accessing the file.xltx
copying a rule
from there and applying it to a previously opened sheet of the book.xlsm
the fact is that I have already tried, either I don't know something, or you have a different version, not 2016 excel
From which sheet and which range in file.xltx do you want to copy the formatting to which sheet and which range in book.xlsm?
From what sheet
1st
and in what range
is all
in the file.xlsx do you want to copy
formatting to which sheet
1st
and in what rangeis all
in book.xlsm?
in .xltx I have a rule that applies to the entire sheet
XML code from .xltx
...
- <conditionalFormatting sqref="A1:XFD1048576">
- <cfRule priority="1" dxfId="0" type="expression">
<formula>xxx</formula>
</cfRule>
</conditionalFormatting>
...The macro could look like this:
Sub CopyFormatting() Workbooks("file.xltx").Worksheets(1).Cells.Copy Workbooks("book.xlsm").Worksheets(1).Cells.PasteSpecial Paste:=xlPasteFormats End Sub