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.


* This function does not recognize formatting if it is applied via conditional formatting.
* The equivalent VBA function is COUNTFORMAT


alt text

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