Broadly speaking, no, there are not any functions that do that. Functions look at what is "inside" the cell, and formatting is applied "on top" of them.
Instead what you're better off doing is just running a COUNTIF on the range of formatted cells with the same criteria you used to apply the CF in the first place.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
douggie 
Register To Reply
Bookmarks