Formula to Count Condional Formatting

[lmarsh1693]

Is it possible to create a formula that will count the
number of instances in range that meet a specified
conditional format? For example, I want to count the
number of cells that are conditionally formatted Blue.
Thank you.

Larry

 

[Kostis Vezerides]

Larry,
if the cells have *conditional* formatting, then the
condition of formatting can be used for formulas like
COUNTIF() or array formulas using the same criteria used
for the format condition.

Write more if you need additional assistance.

Kostis Vezerides

 

[hgrove]

(e-mail address removed) wrote...

Is it possible to create a formula that will count the number of
instances in range that meet a specified conditional format? For
example, I want to count the number of cells that are
conditionally formatted Blue.

Not easily. It requires VBA. It'd be much. much easier just to use th
same criteria in such a formula as you use in conditional formatting
That is, if cells conditionally formattde blue were those greater tha
10, you could use

=COUNTIF(YourRangeHere,">10"