Forum Discussion
Excel Conditional Formatting not functioning correctly after copying range to another sheet
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 Sergei,
Thank you for your reply.
If I copy the formula it does not work correctly.
However, by doing this I found out what happens:
the original conditional formatting formula in sheet A: "=ABS(S38/S39)>=Admin.TH.Person.high"
becomes this on sheet B:
"=ABS(A!S38/A!S39)>=Admin.TH.Person.high"
So: the formula in sheet B keeps refering to sheet A. That is not what I want... I want to have the cond. format formula unchanged, ie. refering to S38 and S39 on sheet B. Is that possible?
I overlooked this before.
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 ?)
