COUNTFORMAT

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??


alt text

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext