COUNTFORMAT

COUNTFORMAT(range, example_cell, check_background, check_font)
Returns the number of cells that have a particular cell color or font color.

rangeThe range of cells you want to count.
example_cellThe 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

 A
1??


THE BUSINESS

Better Solutions Ltd

London, N20 8LU

Incorporated 2004

VAT No 840-0533-67

Company No 05155080