Count Conditional Format Cells

[drose1105]

Hi,
I am trying to count the Conditionally Formatted cells located in cells B9:B18 and place the values in A5 - D5. Range B9:B18 have a conditional format rule is in the picture below.

I have searched this a lot on the internet, but cannot find the answer. I can only find counting cells based on their cell color but not on conditional formatted cells.

I think this requires a User Defined Function but I can't figure it out.

Please help.

 

[Joe4]

Use COUNTIFS formulas that use the same criteria you used in your Conditional Formatting rules.
See here: How to count number of cells between two values or dates in Excel?.

 

[Peter_SSs]

Joe posted while I was setting up a sample sheet, but this is basically what he suggested - use the same rules to count as you did with the CF.

23 07 17.xlsm
	A	B	C	D
4	Green	Yellow	Orange	Red
5	1	4	2	3
6
7
8
9		183%
10		46%
11		82%
12		31%
13		77%
14		63%
15		40%
16		95%
17		82%
18		71%
Count CF

Cell Formulas
Range	Formula
A5	A5	=COUNTIF(B9:B18,">.995")
B5	B5	=COUNTIFS(B9:B18,">=0.75",B9:B18,"<=0.995")
C5	C5	=COUNTIFS(B9:B18,">=0.5",B9:B18,"<=0.749")
D5	D5	=COUNTIF(B9:B18,"<0.501")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B9:B18	Cell Value	between 0.5 and 0.749	text	NO
B9:B18	Cell Value	between 0.75 and 0.995	text	NO
B9:B18	Cell Value	<0.501	text	NO
B9:B18	Cell Value	>0.995	text	NO

 

[drose1105]

Thanks Joe4. I was way overthinking this and didn't even think about using a simple Countif formula. Thanks so much!!

 

[Joe4]

You are welcome.
Glad we were able to help!