You can apply the UDF function like this:
The function should be placed in the universal module.
The first argument to the function is the range in which we count cells. The second argument is the address of the reference cell of the color we want to count.
Attention! The function does not recalculate automatically when changing the color from the palette.
This is converted when editing one of the cells of the counted range, as well as when coloring cells with the format painter. It can also be converted with the F9 key.
Only counts hard (not conditional) formatting.
The file format must be able to run macros.
Code: VBScript
Log in, to see the code
The first argument to the function is the range in which we count cells. The second argument is the address of the reference cell of the color we want to count.
Attention! The function does not recalculate automatically when changing the color from the palette.
This is converted when editing one of the cells of the counted range, as well as when coloring cells with the format painter. It can also be converted with the F9 key.
Only counts hard (not conditional) formatting.
The file format must be able to run macros.
