Conditional formatting to apply a color gradient based on cell contents?
Google Sheets have a very useful feature that lets you set a conditional color gradient (i.e., white to red, or red to green shadings, etc.) that adjusts based on either min/mid/max values or based on absolute values.
Is this kind of thing possible with the existing conditional formatting feature? Or would I need to add each color manually?