Category - Formatting

List of user defined functions

NUMBERFORMATGETReturns the number format that has been applied to a particular cell.
COUNTFORMATReturns the number of cells that have a particular cell color or font color.
COUNTFORMAT_CELLCOLORReturns the number of cells that have been formatted with a particular colour.
COUNTFORMAT_FONTBOLDReturns the number of cells that have been formatted in bold.
COUNTFORMAT_FONTCOLORReturns the number of cells that have been formatted with a particular font colour.
COUNTTEXTCELLSReturns the number of cells that contain text.
FORMATGETReturns a specific formatting attribute from a particular cell.
FORMATGET_FONTNAMEReturns the font name used to format a particular cell.
FORMATGET_FONTSIZEReturns the font size used to format a particular cell.
SUMFORMATReturns the sum of all the values that have been formatted with multiple attributes.
SUMFORMAT_CELLCOLORReturns the total value of the numbers that have been formatted with the same colour.
SUMFORMAT_FONTBOLDReturns the sum of all the values that have been formatted in bold.
SUMFORMAT_FONTCOLORReturns 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