title: Excel+VBA How can I set the bg colour of a cell using its own contents?
body: <p>I'm trying to get a sheet where entering an RGB value into a cell will set the background colour to that value. I know I can use</p>
  
  <pre><code>Range("A1:BE57").Interior.Color = RGB(127, 255, 127)
  </code></pre>
  
  <p>to set the background for the whole range to any one colour, but I would like each individual cell in that range to pull from its own contents.</p>
  
  <p>ideally just having </p>
  
  <pre><code>Range("A1:BE57").Interior.Color = RGB(.Value)
  </code></pre>
  
  <p>where .Value would be replaced with the actual contents of the cell (i.e. 127, 255, 127) for each instance in the range. Though i'm aware it is unlikely to be that simple.</p>
  
  <p>is this possible?</p>