2.9.4 wcolor2mask

Brief Information

Mask worksheet cells that has been formatted

Minimum Origin Version Required: 2019

wcolor2mask;

wcolor2mask Mode:=1;

wcolor2mask Mode:=2;

Display
Name

Variable
Name

I/O
and
Type

Default
Value

Description

Range

irng

Input/Output

Range

Specify the input data range.

What to convert

Mode

Input

int

Specify how to decide the cells to be masked.

Option list:

0=Cells with colored background
Mask the cells have been filled color.
1=Cells with colored Text
Mask the cells with colored text/numberic. Not for the default color "black".
2=Cells with conditional format
Mask the cells with conditional format.