title: Conditional Formatting with icon sets and relative referencing in excel
body: <p>I was wondering if there is any way to use relative referencing with icon sets in excel.  Ideally I would like to lock the row whilst allowing the column to change as the column is copied and pasted across the worksheet (ex. D$3).  Excel is telling me that I'm not able to use relative referencing with icon sets.</p>
  
  <p>for clarification, what I'm trying to do is apply an icon set based on the relation between the current day and the target date of a project to be completed.  </p>
  
  <p>-The cell will show a checkmark so long as there is at least a week before the target date or if the cell reads 100%.</p>
  
  <p>-If there are less than 7 days between the target date and current date then it will show an exclamation mark.</p>
  
  <p>-otherwise show an x when the current day is the same as the target date and the cell's value is not 100%</p>
  
  <p>the code that is being used as a condition is:</p>
  
  <pre><code>=OR(TODAY()+7-$D$14,$D$12=100)
  </code></pre>
  
  <p>What I would like is something equivalent to:</p>
  
  <pre><code>=OR(TODAY()+7-D$14,D$12=100)
  </code></pre>
  
  <p>I just don't know how to go about doing that
  thanks in advance</p>
  
  <p>below is the formatting rule window:
  <img src="https://i.stack.imgur.com/WyFmW.jpg" alt="Formatting rule"></p>