title: Conditional formatting with the icon set and a formula
body: <p>Basically I am trying to use the conditional formatting icon set that is a green dot, orange dot and red dot.</p>
  
  <p>If my value is smaller than my formulas value, display the green dot.</p>
  
  <p>If my value is equal to my formulas value, display the orange dot.</p>
  
  <p>If my value is more than my formulas value, display the red dot.</p>
  
  <p>This is the EXACT formula I am trying to use:</p>
  
  <pre><code>VLOOKUP(product_ID,product_db,3,FALSE)
  </code></pre>
  
  <p><code>product_ID</code> is the cell next to the cell I am trying to apply the conditional formatting to. <code>product_db</code> is a large table within another worksheet.</p>
  
  <p>Although, when I am trying to use this, the formatting is not applied to my cell at all. No dots are displayed.</p>
  
  <p>I believe it is because of my formula. Any ideas?</p>
  
  <hr>
  
  <p>EDIT:</p>
  
  <p>Here are some screen shots of what is happening:</p>
  
  <p>Here is the quantity before the conditioning:</p>
  
  <p><img src="https://i.stack.imgur.com/5VRTj.png" alt=""></p>
  
  <p>Here is the conditioning with the formula being: <code>=VLOOKUP(invoice_product,PRODUCT_DATABASE,3,FALSE)</code></p>
  
  <p><img src="https://i.stack.imgur.com/gjY0F.png" alt="enter image description here"></p>
  
  <p>The quantity is then the EXACT same as the first image, unchanged. The value that my formula should return is 2, hence the orange dot should be displayed.</p>