title: Link to another workbook using conditional formatting in Excel
body: <p>How can i use conditional formatting to extract data from other workbook? </p>
  
  <p>I tried:</p>
  
  <pre><code>=IF(LEFT(B26,3)="SSS",VLOOKUP(B26,'XXX.xls!$A$4:$E$119,4,FALSE)) 
  </code></pre>
  
  <p>But I get this error message:</p>
  
  <blockquote>
    <p>You may not link to other workbook via conditional formatting</p>
  </blockquote>
  
  <p>What can I do with this situation? People out there mentioned "define name" but I'm not sure how can it be done.</p>