Worksheet: Conditional Formatting: Heatmap
Apply conditional formatting to worksheet cells using a heatmap
1. wheatmap rng:=[Book1]Sheet1!A:B name:="C1R1-C4R0";
2. wheatmap rng:=[Book1]Sheet1!A:B name:="C1R1-C2R0" trcolor.method:=0 trcolor.from:=31306751 trcolor.to:=32497615 trcolor.head:=19 trcolor.tail:=20;
3. wheatmap rng:=[Book1]Sheet1!A:B name:="C1R1-C2R0" trlevel.rescale:=0 trlevel.from:=5 trlevel.to:=30 trlevel.by:=0 trlevel.val:=3 trlevel.first:=6 trcolor.autocolor:=1 trcolor.method:=3 trcolor.name:="Soft Thermometer";
Please refer to this page for additional option switches when accessing the x-function from script.
Input
Range
string
int
TreeNode
Use heatmap to color cells according to the level setting.
wcolor, wcolordup
Keywords:cell coloring