Category - Formatting
List of user defined functions
| NUMBERFORMATGET | Returns the number format that has been applied to a particular cell. |
| COUNTFORMAT | Returns the number of cells that have a particular cell color or font color. |
| COUNTFORMAT_CELLCOLOR | Returns the number of cells that have been formatted with a particular colour. |
| COUNTFORMAT_FONTBOLD | Returns the number of cells that have been formatted in bold. |
| COUNTFORMAT_FONTCOLOR | Returns the number of cells that have been formatted with a particular font colour. |
| COUNTTEXTCELLS | Returns the number of cells that contain text. |
| FORMATGET | Returns a specific formatting attribute from a particular cell. |
| FORMATGET_FONTNAME | Returns the font name used to format a particular cell. |
| FORMATGET_FONTSIZE | Returns the font size used to format a particular cell. |
| SUMFORMAT | Returns the sum of all the values that have been formatted with multiple attributes. |
| SUMFORMAT_CELLCOLOR | Returns the total value of the numbers that have been formatted with the same colour. |
| SUMFORMAT_FONTBOLD | Returns the sum of all the values that have been formatted in bold. |
| SUMFORMAT_FONTCOLOR | Returns the total value of the numbers that have been formatted with the same font colour |
| NUMBERFORMATGET Returns the number format that has been applied to a particular cell. |
| COUNTFORMAT Returns the number of cells that have a particular cell color or font color. |
| COUNTFORMAT_CELLCOLOR Returns the number of cells that have been formatted with a particular colour. |
| COUNTFORMAT_FONTBOLD Returns the number of cells that have been formatted in bold. |
| COUNTFORMAT_FONTCOLOR Returns the number of cells that have been formatted with a particular font colour. |
| COUNTTEXTCELLS Returns the number of cells that contain text. |
| FORMATGET Returns a specific formatting attribute from a particular cell. |
| FORMATGET_FONTNAME Returns the font name used to format a particular cell. |
| FORMATGET_FONTSIZE Returns the font size used to format a particular cell. |
| SUMFORMAT Returns the sum of all the values that have been formatted with multiple attributes. |
| SUMFORMAT_CELLCOLOR Returns the total value of the numbers that have been formatted with the same colour. |
| SUMFORMAT_FONTBOLD Returns the sum of all the values that have been formatted in bold. |
| SUMFORMAT_FONTCOLOR Returns the total value of the numbers that have been formatted with the same font colour |
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext