title: Cell shader based on cell formula with conditional formatting
body: <p>I am trying to develop a code that color-codes cells based on cell contents i.e. based on the following criteria</p>
  <ol>
  <li>Hardcoded cells</li>
  <li>Cells with formula</li>
  <li>Cells with links to other sheets</li>
  <li>Cells with external links</li>
  </ol>
  <p>The issue in here is that the code I have been able to develop uses actual background colors to color code the cells.</p>
  <p>I am looking for a way to use conditional formatting to run the same code so that I can develop a code to unshade the cells and it restores to original formatting in the sheet.</p>
  <p>Can someone help me converting the code to use conditional format?</p>