A simple Conditional formatting question I think!!

[Javi]

Hi All,
In the table below I would like to apply formatting to C2 if its value is found in this range G2:G18
I tried =if(c2=G2:G18) and also =c2=G2:G18 with no luck.
Thanks in advanced

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L	M	N
1		Team Names		Team			W or L		Points		W or L		Team
2	1	Arizona Cardinals
3	2	Atlanta Falcons
4	3	Baltimore Ravens		2		Atlanta Falcons
5	4	Buffalo Bills
6	5	Carolina Panthers		1		Arizona Cardinals
7	6	Chicago Bears		4		Buffalo Bills
8	7	Cincinnati Bengals
9	8	Cleveland Browns
10	9	Dallas Cowboys
11	10	Denver Broncos
12	11	Detroit Lions
13	12	Green Bay Packers
14	13	Houston Texans
15	14	Indianapolis Colts
16	15	Jacksonville Jaguars
17	16	Kansas City Chiefs
18	17	Miami Dolphins
19	18	Minnesota Vikings
Week1 (2)

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>

 

[mancubus]

try

CountIf(G2:G18,C2)>0

 

[jasonb75]

try

CountIf(G2:G18,C2)>0

For info, you don't need the >0 argument on the end, any numeric value other than 0 evaluates to true in a logical test.

You could also use

=MATCH(C2,G2:G18,0)

 

[Javi]

Thank you both for the reply!!

This is what worked...

=COUNTIF($G$2:$G$18,C2)>0

Could not get it to work without $

Thanks!!!!