title: Generating colors HEX in Excel
body: <p>I have data saved in Excel as numbers with calculated cumulative result (sum of all cumulative values is 100). </p>
  
  <pre><code>***********************************
  *Result*Cumulative*      RGB      *
  * 230  *    30    * HEX (darkest) *
  * 100  *    10    * HEX (lightest)*
  *  ... *   ...    *      ...      *
  ***********************************
  </code></pre>
  
  <p>I want to write function/generate color "code" in HEX which will be result of cumulative values. The highest value should have the darkest color and the lowest value should have the lightest color.</p>
  
  <p>I need to export this result in CSV to another program so it's not possible to use build in function to generate color.</p>