Forum Discussion
Pasting formats from conditional formatting
Hi J_Wils
I think the issue here is the fomatting rule. According to the first screenshot, the rule checks for blank cells in column $U and also refers to $Z, $AA and some more columns.
So when you copy over the highlighted records to the new workbook, the formatting rule will still check those references in $U, $Z and so on. And I expect that they do not exist in the target sheet, therefore the formatting rule does not work.
So you could either make sure, the target sheet has exactly the same structure, references etc. as the source sheet.
Or you just need to apply manually the background color right after copying, when the rows are still selected. And ignore the formatting rule.
I still think it's weird excel doesn't treat conditional formats the same as manually applying formatting. Or at least it's interesting that copying a format that is done through conditional formatting doesn't actually copy the formatting itself but just the rule.
It depends on how you use absolute/relative references in conditional formatting rule. In general it shall work.
- Well the basic idea is I want these rows to be highlighted into a new workbook that will eventually be saved as an CSV file. The file will then be uploaded to our accounting software. So, these highlighted lines will need to be deleted and having them highlighted will make it easier for the people to know what to delete. Or maybe even for a macro to be written to delete them based off the color. How would relative referencing work for that?
