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
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
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>