Copy the result of a conditional format with the values to another cell

Copper Contributor

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

2 Replies

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.