COUNTFORMAT
COUNTFORMAT(range, example_cell, check_background, check_font)
Returns the number of cells that have a particular format.
| 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
* Returns the number of cells that have been formatted with multiple attributes.
* This function does not recognize formatting if it is applied via conditional formatting.
This function will not update automatically every time a cell format changes although pressing F9 will work.
Returns the number of cells that have been formatted in bold.
Returns the number of cells that have been formatted with a particular font colour.
Need a function that can detect any cell formatting (not a specific colour)
4 Functions that allow you to count different types of formatting.
* You can use the built-in COUNT function to return the number of numerical values.
 |
 |
MORE FUNCTIONS
COUNTSUBSTRING function to return the number of times a substring occurs in a larger text string.
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext