Count cell formatting

[braydon16]

Does anyone have a way to count the number of cells formatted a specific way?

[Shijesh Kumar]

Hi,

We can count the no. of cells containing formating .
But we should first know what type of formatting are there in the cells.

For example : Below is the VBA code to calculate the number of cells which is YELLOW in color for Range ("A1:A20")

Similar codes can be written for any other formatting present in the cells.

Please Login or Register  to view this content.

Thanks

http://excelguru.iphorum.com/

[VBA Noob]

Shijesh Kumar,

Please wrap your code next time as per forum rules below

VBA Noob

[Shijesh Kumar]

Thanks,
I was not aware of that.

It will be taken care from the next time..

But i would like to thank you for creating such a wonderful forum