Highlight with two conditions

[VBAnewbie82]

How do I highlight values that appear at least three times with matching value in different column?

For example below I would like to highlight values in column C that appear at least three times and they have matching value in column A. Right conditional formatting with right formula should highlight only values in cell C1, C3 and C7 for they have matching value "15" in column C and matching value "9999" in column A.

	A	B	C
1	9999	Randomtext1	15
2	2222	Randomtext2	20
3	9999	Randomtext3	15
4	4444	Randomtext4	15
5	5555	Randomtext5	20
6	6666	Randomtext6	20
7	9999	Randomtext7	15

 

[Joe4]

You can use Conditional Formatting to do this. Follow these steps:
1. Select the range C1:C7
2. Go to Conditional Formatting
3. Select "New Rule"
4. Select the "Use a formula to determine which cells to format" option
5. Enter this formula:

=COUNTIFS(A:A,A1,C:C,C1)>=3

6. Click on the format, and select your desired format
7. Click OK

This should do what you want.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D
1	A	B	C
2	9999	Randomtext1	15
3	2222	Randomtext2	20
4	9999	Randomtext3	15
5	4444	Randomtext4	15
6	5555	Randomtext5	20
7	6666	Randomtext6	20
8	9999	Randomtext7	15
9
10
11
12
Summary

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2:C13	Expression	=AND(C2<>"",COUNTIFS($A$2:$A$100,A2,$C$2:$C$100,C2)>2)	text	NO