title: Conditional formatting cells with lowest value per row excluding specific columns
body: <p>I've looked around but haven't been able to find an exact answer to this question without learning everything there is to know about excel formulas.</p>
  <p>I'm trying to use one conditional formatting rule to highlight one specific cell in each row in a dataset.</p>
  <p>I've got that working with this: <code>=AND(D5&lt;&gt;0,D5&lt;=SMALL(IF($D5:$W5&lt;&gt;0,$D5:$W5),1))</code></p>
  <p>The next part is having the formula exclude hidden columns/columns that have the header &quot;USA&quot; for that I have this formula: <code>=SEARCH(&quot;US&quot;,D3)=1</code></p>
  <p>Which works to highlight the cells with USA written in them.</p>
  <p>I need to combine these two formulas to have it highlight the single lowest value in each visible row.</p>
  <hr />
  <p>On a separate note I then want the highlighted value displayed at the end of the data set. This way if I update the document with a lower price it will automatically update the rest of the sheet with this information.</p>