Forum Discussion
Copy the result of a conditional format with the values to another cell
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 cel...
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.
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.