Returns the background color of a cell.
@CellFillColor([<Address>])
| Argument Name | Description |
|---|---|
| Cell | Optional (defaults to the selected cell); The address of the cell. |
function example
| A | B | C | D | |
|---|---|---|---|---|
| 1 | January | February | March | |
| 2 | 1000.0 | |||
| 3 | 1001.0 | |||
| 4 | 1002.0 |
| Procedure | ||||||
|---|---|---|---|---|---|---|
| Method | Overload | ErrorHandlingMode | ||||
| Argument | Value | Comment | ||||
| OnAfterBuild | ||||||
| SetEntry | Text | |||||
| Address | Data.Range | |||||
| CellByCell | True | |||||
| CellCondition | ||||||
| Entry | @CellFillColor() | |||||
| A | B | C | D | |
|---|---|---|---|---|
| 1 | January | February | March | |
| 2 | 1000.0 | Color [A=255, R=51, G=153, B=102] | Color [A=255, R=0, G=255, B=0] | Color [A=255, R=204, G=255, B=204] |
| 3 | 1001.0 | Color [A=255, R=128, G=0, B=0] | Color [A=255, R=255, G=102, B=0] | Color [A=255, R=255, G=153, B=204] |
| 4 | 1002.0 | Color [Transparent] | Color [Transparent] | Color [Transparent] |