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 |
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext