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.
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.
Thanks for your help! That solves my issue. I needed a small adjustment in my VBA copy code.
Does it mean, I need to edit the Copy code written in VBA (If so can you give direction of how to do it ?)
