Jan 14 2019 04:22 AM
Answer
I have two open files: File A and file B
Fil A has in cel A1 a conditional format (if cell B2= "red" than is A1 the result of the codintional condition (REd).
Question ?
I want to copy cell A1 to file B A1 with the result of the conditional format (RED) not the conditional settings
Jan 17 2019 06:36 AM
I suspect it's because the copied cell is locked with the "$" symbol.
Select the pasted cell in file "B" and check the Conditional formatting is pointing the right place.
Jan 17 2019 10:18 AM
It doesn't matter which CF rules are applied. If copy/paste keeping format of the source cell, CF rules will be applied to the destination rule as well.