Counting Conditionally Highlighted Cells

[memoorefield]

I can't figure out how to count the number of cells that are highlighted in a conditionally formatted column in Excel 2013. I have read through and tried many of the VBA solutions on this site but none seem to work in my spreadsheet.

Here's a general overview of the spreadsheet - Column A is conditionally formatted to highlight cells with a number that falls outside of a range defined in column B. However there are about 18 different conditions. If I need the count of all the highlighted cells to show in cell A1000 how would I do this?

 

[Joe4]

Welcome to the Board!

Conditional Formatting is based on formulas/conditions that you set-up.
You should be able to use those same formulas/conditions in a COUNTIF, COUNTIFS, or SUMPRODUCT formulas to get your counts.

See here: http://www.techonthenet.com/excel/formulas/countifs.php
and http://www.techonthenet.com/excel/formulas/countif.php

 

[memoorefield]

Thanks Joe, but I must still be doing something wrong because I'm getting a 0 as the answer when I know there are multiple highlighted cells. I believe it's because of the criteria used in the conditional formatting.

An example of one of the conditions is below:

AND(N2="55% EQUITY",OR(D2<45,D2>65))

 

[Joe4]

An example of one of the conditions is below:

AND(N2="55% EQUITY",OR(D2<45,D2>65))

How many rows is this applied to?

What version of Excel are you using (COUNTIFS is only available in version 2007 and newer)?

 

[memoorefield]

990 rows in excel 2013

 

[Joe4]

OK. Here is one way to get that count:

=COUNTIFS(N2:N990,"55% EQUITY",D2:D990,"<45") + COUNTIFS(N2:N990,"55% EQUITY",D2:D990,">65")