title: Google Spreadsheet : Formatting background color based on cell value
body: <p>I'm trying to color the background of a bunch of cells based on their value and a specified range.</p>
  
  <p>So lets say the range is 1.0-3.0, then the cells with 3.0 are colored black and the ones with 1.0 are colored white with cells having intermediate value getting a shade of grey on a linear scale.</p>
  
  <p>I'm sure scripting is involved. Any help would be appreciated</p>