title: How to make the color of an Excel cell depend on the value of another cell in another sheet?
body: <p>Here is the deal.</p>
  
  <p>Let's say Sheet 1 contains numerical data over . For instance :</p>
  
  <pre><code>Country Population  GDP  ...
  India       V1       V4  ...
  Russia      V2       V3  ...
    ...       ...     ...  ...
  </code></pre>
  
  <p>On sheets 2, 3, ..., n, each country is represented by a cell.</p>
  
  <p>I would like :
  - Sheet 2 to colorize the various countries depending on Column 2 of Sheet 1
  ...
  - Sheet n to colorize the various countries depending on Column n of Sheet 1</p>
  
  <p>(like a heatmap)</p>
  
  <p>I found links describing how to colorize :
  - a cell depending on the value it contains (trivial use of Conditional Formatting)
  - a cell depending on the value of another cell in the same sheet</p>
  
  <p>What I need is a method to colorize a cell depending on the value of a cell in another sheet.</p>
  
  <p>What would be needed to achieve this ? Some VBA or just a few mouse clicks ... ?</p>