Formula to Count Condional Formatting

  • Thread starter Thread starter lmarsh1693
  • Start date Start date
L

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
 
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
 
(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.
Click to expand...

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"
 
Back
Top