Select worksheet cells using specified condition
1. wcellsel rng:=1! cond:=le val:=3; // whole sheet to select all cells < 3
2. wcellsel rng:=1 c:=gt v:=0.5; // sel col(1) for cells > 0.5
3. wcellsel c:=none; // clear all selection in active sheet
4. wcellsel;// same as above since none is the default
Please refer to the page for additional option switches when accessing the x-function from script
Input/Output
Range
Input
int
Option list:
double
This function is used to set cell(s) color with specified condition.