COUNTFORMAT
COUNTFORMAT(range, example_cell, check_background, check_font)
Returns the number of cells that have a particular cell color or font color.
range | The range of cells you want to count. |
example_cell | The cell containing the formatting you want to count. |
check_background | (Optional) Whether to check the background colour. |
check_font | (Optional) Whether to check the font attributes. |
Remarks
* This function does not recognize formatting if it is applied via conditional formatting.
* The equivalent VBA function is COUNTFORMAT