AnswerI have two open files: File A and file BFil 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
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.