wcellcolor

Brief Information

Set cell(s) color to fill color or set the selected character font color to Font color.

1. wcellcolor 1[1]:2[3] color(red); // active sheet col(1) row(1) to col(2) row(3) set to red

2. wcellcolor 2 color(blue); // whole col(2) set to blue

3. wcellcolor 3 color(red) type:=font; // whole col(3) set font color to red

4. wcellcolor i:=[Book1]Sheet1!col(B)[2] c:=color(127,255,127); //set to specific RGB

Display Name	Variable Name	I/O and Type	Default Value	Description
Input	irng	Input Range	<active>	Specify cell range to fill
Color	color	Input int	0	Specify the color. Color index from 0 (Black). You can also select color from Fill Color drop-down list on the Style tool bar.
Type	type	Input int	fill	Set the selected cells color to Fill Color or the selected font color to Font Color. Option list: fill:Fill Color Fill the cell color font:Font Color Change the select font color
Undo	undo	Input int	0	Specify whether can undo the operation

This function is used to set cell(s) color to fill color or set the selected font color to Font color.

For more examples, please refer to XF Script Dialog (press F11).