Forum Discussion

Rabo123's avatar
Rabo123
Copper Contributor
Jan 14, 2019

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 cell A1 to file B A1 with the result of the conditional format (RED)  not the conditional settings

excel
ramadan

2 Replies

Sort By
  • Nauthstar's avatar
    Nauthstar
    Iron Contributor
    Jan 17, 2019

    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.

     

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jan 17, 2019

      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.

Resources