Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-314503%22%20slang%3D%22en-US%22%3ECopy%20the%20result%20of%20a%20conditional%20format%20with%20the%20values%20to%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314503%22%20slang%3D%22en-US%22%3E%3CP%3EAnswer%3CBR%20%2F%3EI%20have%20two%20open%20files%3A%20File%20A%20and%20file%20B%3CBR%20%2F%3EFil%20A%20has%20in%20cel%20A1%20a%20conditional%20format%20(if%20cell%20B2%3D%20%22red%22%20than%20is%20A1%20the%20result%20of%20the%20codintional%20condition%20(REd).%3C%2FP%3E%3CP%3EQuestion%20%3F%3CBR%20%2F%3EI%20want%20to%20copy%20cell%20A1%20to%20file%20B%20A1%20with%20the%20result%20of%20the%20conditional%20format%20(RED)%26nbsp%3B%20not%20the%20conditional%20settings%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-314503%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eramadan%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320308%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20the%20result%20of%20a%20conditional%20format%20with%20the%20values%20to%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320308%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20doesn't%20matter%20which%20CF%20rules%20are%20applied.%20If%20copy%2Fpaste%20keeping%20format%20of%20the%20source%20cell%2C%20CF%20rules%20will%20be%20applied%20to%20the%20destination%20rule%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320143%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20the%20result%20of%20a%20conditional%20format%20with%20the%20values%20to%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320143%22%20slang%3D%22en-US%22%3E%3CP%3EI%20suspect%20it's%20because%20the%20copied%20cell%20is%20locked%20with%20the%20%22%24%22%20symbol.%3CBR%20%2F%3ESelect%20the%20pasted%20cell%20in%20file%20%22B%22%20and%20check%20the%20Conditional%20formatting%20is%20pointing%20the%20right%20place.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Rabo123
Occasional Visitor

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.