Counting number of cells with certain conditional formatting

[TOTCOM11]

Using Excel, I am trying to store the number of times a certain condtional format happens into a cell. For example, let's say I'm looking at cells A1 through A10 and B1 through B10. I want to look at all of these cells and count the number of times there are bold formatting, and store that number in A12. And I also want to find the number of times there is formatting with yellow fill color and store that number in A13. Does anyone know how I can do this? If you need any clarification of what I'm trying to accomplish, let me know.

Thanks,
TOTCOM11

 

[PHV]

Have a look at the FormatConditions collection of the Range object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

This was answered in the Office Forum.

Skip,

_{[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it!}