Forum Discussion

Deleted's avatar
Deleted
Oct 02, 2018

Excel Conditional Formatting

Hello! I am doing conditional formatting between to cells which is working. The issue is that when I try to copy the formula to paste it to a new row it updates the "applied to" cell but now the updated cell. In the image below it is not updating "$D$53" when pasting. Is there a way to paste it so that it updates both cells?

 

excel
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Oct 02, 2018
    to copy a cell with Data Validation - use paste specials (Validation)
    HTH
    • Deleted's avatar
      Deleted
      Oct 03, 2018

      I am copying Cell 73 and pasting on cell 74. It updates the "applied to" (=$C$74) cell but not the other one, it stays at "=$D$73="Sales"". I need it at $D$74. I have been having to go in and manually update each one.

      • Lorenzo Kim's avatar
        Lorenzo Kim
        Bronze Contributor
        Oct 03, 2018

        remove the $ from the number like:

        $D$73  to  $D73  - then copy..

        the dollar sign signifies a definite location - it will not change when copied elsewhere.

        hope this helps..

         

Resources