Forum Discussion
Solved
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 diffe...
=$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.
=$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!
