Cell count by multiple conditions

[sharpeye]

Hello everyone
I need a little help. Im tring to do a count of cells based on colours. The first colour is the font which, if the font is yellow (based on the probability of a result being over a certain value, in this case 85%+.) when the result is positive, I colour the cell green, if not I colour the cell red. Id like to count all the cells in a given range that are both green in colour with yellow font. I already have the commands in place that can count cell colour and font colour but have no idea how to combine both in a count.

I count the font colour using
=CountCellsByFontColor(M2:M95,M1)

I count cell colour using
=CountCellsByColor(M2:M95,M1)

I would like to create a cell that would only count the cells that meet both criteria
Any ideas would be amazing
Many thanks

 

[sharpeye]

The way I interpreted your original post was that you were using UDFs to count the number of cells in a given range - M2:M95 - where the cells' format matched the format of another given cell - M1. The UDF I wrote in post #2, when placed in a standard module and applied to the same ranges using some sample data, works like this:

test.xlsb
	M	N	O	P	Q	R	S
1	1%	= 'template' cell
2	81%	46	= Count of cells in M2:M95 matching 'template'
3	91%
4	73%
5	85%
6	75%
7	76%
8	95%
9	87%
10	74%
11	85%
12	84%
13	73%
14	81%
15	77%
16	72%
17	93%
18	87%
19	94%
20	93%
21	89%
22	98%
23	75%
24	88%
25	92%
26	70%
27	81%
28	81%
29	91%
30	73%
31	85%
32	75%
33	76%
34	95%
35	87%
36	74%
37	85%
38	84%
39	73%
40	81%
41	77%
42	72%
43	93%
44	87%
45	94%
46	93%
47	89%
48	98%
49	75%
50	88%
51	92%
52	70%
53	81%
54	81%
55	91%
56	73%
57	85%
58	75%
59	76%
60	95%
61	87%
62	74%
63	85%
64	84%
65	73%
66	81%
67	77%
68	72%
69	93%
70	87%
71	94%
72	93%
73	89%
74	98%
75	75%
76	88%
77	92%
78	70%
79	81%
80	81%
81	91%
82	73%
83	85%
84	75%
85	76%
86	95%
87	87%
88	74%
89	85%
90	84%
91	73%
92	81%
93	77%
94	72%
95	93%
96
Sheet3

Cell Formulas
Range	Formula
N2	N2	=CountAllColors(M2:M95,M1)

I'd be keen to know if you were able to try it out, or if I'd misinterpreted your original intention.

Thats perfect, works like a dream. Many many thanks

 

[kevin9999]

Thats perfect, works like a dream. Many many thanks

Glad it worked, and thanks for the feedback.