Forum Discussion
Copy formatting generated by conditional formatting
How do I copy the actual formatting from one range of cells to another, where the formatting on the source cells is present due to conditional formatting?
The destination cells have completely different content so I don't want to paste the conditional formatting rules, just the actual formatting.
If the original cells were formatted with normal (non-conditional) formatting, I'd use the format painter. But doing that here only copies the conditions, which won't work on the destination cells, nor do I want it to.
E.g. I have a column of numbers where all the 1s are highlighted yellow. I want to copy that formatting to a new column that has text content, so that I can see yellow in any row where the original column had a 1.
Thank you
=$C$1:$C$20;$F$1:$F$20If i correctly understand what you want to do you can change the "applies to" range of the conditional format. In the attached example you can apply the above range.
2 Replies
=$C$1:$C$20;$F$1:$F$20If i correctly understand what you want to do you can change the "applies to" range of the conditional format. In the attached example you can apply the above range.
- Perfect! Had applied the original conditional formatting with a simpler rule, but I see now that if I use a formula referencing the source column and use the applyto as you demonstrated, that works perfectly. Thank you!
