FORMATGET

Returns a specific formatting attribute from a particular cell.

Remarks

* The equivalent VBA function is FORMATGET

FORMATGET_COLORINDEX = ASAPCELLCOLORINDEX(cell)

Returns the color index number of the cell.
If you afterwards change the color in the cell, you have to press Ctrl+Alt+F9 to have the formula recalculated.
This function does not recognize formatting if it is applied via conditional formatting.

Parameters:
cell = The cell to get Excel's number for the fill color from.

FORMATGET_FONTCOLORINDEX = ASAPFONTCOLORINDEX(cell)

Returns the color index number of the font of a cell.
If you afterwards change the font color in the cell, you have to press Ctrl+Alt+F9 to have the formula recalculated.
This function does not recognize formatting if it is applied via conditional formatting.

Parameters:
cell = The cell to get Excel's number for the text color from.

FORMATGET_FONTNAME = ASAPGETFONTNAME(cell)

Returns the name of the font in a cell.
If you afterwards change the font in the cell, you have to press Ctrl+Alt+F9 to have the formula recalculated.
This function does not recognize formatting if it is applied via conditional formatting.

Parameters:
cell = The cell to get the font from.

FORMATGET_FONTSIZE = ASAPGETFONTSIZE(cell)

Returns the font size of a cell.
If you afterwards change the font size in the cell, you have to press Ctrl+Alt+F9 to have the formula recalculated.
This function does not recognize formatting if it is applied via conditional formatting.

Parameters:
cell = The cell to get the font size from.