I'm trying to color the cells of my spreadsheet based on the value I have inputted into the cells. The conditional formatting option does not work, because I would like to color the cells as a continuous gradient between two colors, and not as a set of discrete criteria.

In short, I would like to create a heatmap of my data, with the values in the cells still visible, but the cell colored based on the value in that cell.

Any help is much appreciated.