graded color scale for charts

[claypot2]

In a table, how do I create conditional formatting using a graded color scale?  Similar to what users do in Excel

[jwjackso]

I use the ColorMix functions.  In the example below, I used ColorMix1(Val/10,white(),Red()) in the "Background color expression".