Worksheet: Conditional Formatting: Highlight
Apply conditional formatting to worksheet cells using custom rules.
1. wcolor rng:=[Book1]Sheet1! name:="C1R1-C0R0" trrule.cond1:=4 trrule.val11:=30;
2. wcolor rng:=[Book1]Sheet1! name:="C1R1-C0R0" trrule.cond1:=1 trrule.val11:=10 trrule.join:=1 trrule.cond2:=3 trrule.val21:=5 trrule.fill:=18 trrule.font:=4;
Please refer to this page for additional option switches when accessing the x-function from script.
Input
Range
string
int
TreeNode
Use this X-Function to color cells that the value matchs the condition setting
Example 1: To color the cells containing the specified text.
wcolor rng:=[automobile2]automobile2!3 name:="C3R1-C3R0" trrule.cond1:=7 trrule.text1:=Japan;
Then the cells with text Japan will be colored in the third column.
Example 2: To color the rows containing male info.
wcolor rng:=[Book1]"Categorical Data"!C"Gender" name:="C3R1-C3R0" extend:=1 trrule.cond1:=8 trrule.custom1:="x == "Male"" trrule.fill:=29219323 trrule.font:=-9;
Then rows containing male information will be highlight with specified background color.
wheatmap, wcolordup
Keywords:cell coloring