title: How to protect conditional formatting in google sheet?
body: <p>I have 2 CFs in a sheet that I would like to keep upon copy/pastes you can see the range and formulas below. </p>
  
  <pre><code>CF1 Range : B3:H1001
  CF1 Formula : =($A3&lt;&gt;"")*(B3="") //This one higlights the empty cells in a given range
  
  CF2 Range : A3:R1001  // This one highlights the row if the cell in R column is No.
  CF2 Formula : =$R:$R="No"
  </code></pre>
  
  <p>Is there a way to protect these CFs or apply them again after copy paste ? Thanks !</p>