Forum Discussion
Solved
Excel Conditional Formatting not functioning correctly after copying range to another sheet
Hi,
I have the following situation:
Sheet A has many cells with conditional formatting:
> some of these cells use 'formula to determine which cells to format'
> other cells use 'format onl...
Hi Ben,
In general yes, simple manual copy/paste (Ctrl+C -> Ctrl+V) transfers rules formula without referencing on source sheet. Try to test that with your data, if works you need to adjust your VBA code.
Copy and Paste into a conditionally formatted cell will delete the rules in the pasted cells. If you just paste the values or formulas using Range.PasteSpecial xlPasteValues or Range.PasteSpecial xlPasteFormulas, the conditional formats should still work.