Forum Discussion
Pasting formats from conditional formatting
Hi, This is going to be a little hard to explain but I'll try my best and use photos. I have a conditional formatting custom rule setup to highlight a row of cells based on an If function. I wa...
Ah, ok thanks. Yeah neither of those options would work for what I want to do but thanks for the advice.
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.
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?