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