Spreadsheet: 121337d1316003231-conditional-format-an-intersecting-cell-in-a-table-cf-intersect
Sheet: Sheet1

Reps | Male |  |  |  |  | Female
EXP | M < 30 | M 30-39 | M 40-49 | M 50-59 | M 60+ | F < 30 | F 30-39 | F 40-49 | F 50-59 | F 60+
125 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |  | M 30-39
124 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |  | 122
123 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
122 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
121 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |  |  | < Would like this to highlight on the table at the intersection of M 30-39 and 122.
120 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
119 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
118 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
117 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
116 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
115 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
114 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
113 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
112 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
111 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
110 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
109 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
108 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
107 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
106 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
105 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
104 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
103 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
102 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
101 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
100 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
99 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
98 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
97 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
96 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
95 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
94 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
93 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
92 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
91 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
90 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
89 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
88 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
87 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
86 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
85 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
84 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
83 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
82 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
81 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
80 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
79 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
78 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
77 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
76 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
75 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
74 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
73 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
72 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
71 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
70 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
69 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
68 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
67 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
66 | 9.5 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
65 | 9.5 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
64 | 9.5 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
63 | 9.5 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
62 | 9.5 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
61 | 9.4 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
60 | 9.3 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
59 | 9.2 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
58 | 9.1 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
57 | 9 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
56 | 8.9 | 9.5 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
55 | 8.8 | 9.5 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
54 | 8.8 | 9.5 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
53 | 8.7 | 9.5 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
52 | 8.6 | 9.5 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
51 | 8.5 | 9.4 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
50 | 8.4 | 9.3 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
49 | 8.3 | 9.2 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
48 | 8.1 | 9.2 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
47 | 8 | 9.1 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
46 | 7.8 | 9 | 10 | 10 | 10 | 9.5 | 10 | 10 | 10 | 10
45 | 7.7 | 8.9 | 10 | 10 | 10 | 9.5 | 9.5 | 10 | 10 | 10
44 | 7.5 | 8.8 | 10 | 10 | 10 | 9.5 | 9.5 | 10 | 10 | 10
43 | 7.3 | 8.7 | 9.5 | 9.5 | 10 | 9.5 | 9.5 | 10 | 10 | 10
42 | 7.2 | 8.6 | 9.5 | 9.5 | 10 | 9.5 | 9.5 | 10 | 10 | 10
41 | 7 | 8.5 | 9.5 | 9.5 | 10 | 9.4 | 9.5 | 10 | 10 | 10
40 | 6.8 | 8.3 | 9.5 | 9.5 | 10 | 9.3 | 9.5 | 10 | 10 | 10
39 | 6.5 | 8 | 9.4 | 9.5 | 10 | 9.2 | 9.4 | 10 | 10 | 10
38 | 6.3 | 7.8 | 9.2 | 9.4 | 10 | 9.1 | 9.3 | 10 | 10 | 10
37 | 6 | 7.7 | 9.1 | 9.4 | 10 | 9 | 9.3 | 9.5 | 10 | 10
36 | 5.8 | 7.5 | 9 | 9.3 | 10 | 8.9 | 9.2 | 9.5 | 10 | 10
35 | 5.5 | 7.3 | 8.8 | 9.3 | 10 | 8.8 | 9.1 | 9.5 | 10 | 10
34 | 5.3 | 7 | 8.5 | 9.2 | 10 | 8.6 | 9.1 | 9.5 | 9.5 | 10
33 | 5 | 6.8 | 8.4 | 9.2 | 10 | 8.5 | 9 | 9.5 | 9.5 | 10
32 | 0 | 6.7 | 8.3 | 9.1 | 10 | 8.4 | 8.9 | 9.4 | 9.5 | 10
31 | 0 | 6.5 | 8.1 | 9.1 | 10 | 8.3 | 8.9 | 9.2 | 9.5 | 10
30 | 0 | 6 | 8 | 9 | 10 | 8.2 | 8.8 | 9.1 | 9.5 | 10
29 | 0 | 5.5 | 7.5 | 8.8 | 9.5 | 8.1 | 8.7 | 9 | 9.4 | 10
28 | 0 | 5.3 | 7.3 | 8.5 | 9.5 | 8 | 8.6 | 8.9 | 9.3 | 10
27 | 0 | 5 | 7.2 | 8.3 | 9.3 | 7.5 | 8.6 | 8.8 | 9.2 | 10
26 | 0 | 0 | 7 | 8.2 | 9 | 7.3 | 8.5 | 8.7 | 9.1 | 10
25 | 0 | 0 | 6.5 | 8 | 8.8 | 7.2 | 8.3 | 8.6 | 9 | 10
24 | 0 | 0 | 6 | 7.5 | 8.5 | 7 | 8.2 | 8.6 | 8.8 | 10
23 | 0 | 0 | 5.8 | 7.3 | 8 | 6.5 | 8 | 8.5 | 8.7 | 10
22 | 0 | 0 | 5.5 | 7.2 | 7.5 | 6.3 | 7.9 | 8.4 | 8.6 | 10
21 | 0 | 0 | 5 | 7 | 7 | 6 | 7.8 | 8.3 | 8.6 | 10
20 | 0 | 0 | 0 | 6.5 | 6.5 | 5.8 | 7.6 | 8.2 | 8.5 | 9.5
19 | 0 | 0 | 0 | 6 | 6.3 | 5.5 | 7.5 | 8.1 | 8.4 | 9.5
18 | 0 | 0 | 0 | 5.8 | 6 | 5 | 7 | 8 | 8.3 | 9.4
17 | 0 | 0 | 0 | 5.5 | 5.8 | 0 | 6.8 | 7.8 | 8.2 | 9
16 | 0 | 0 | 0 | 5.3 | 5.5 | 0 | 6.5 | 7.5 | 8.1 | 8.8
15 | 0 | 0 | 0 | 5 | 5.3 | 0 | 6 | 7 | 8 | 8.5
14 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 6.5 | 7.5 | 8
13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 7 | 7.5
12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5.5 | 6.5 | 7
11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 6 | 6.5
10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5.5 | 6
9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 5.7
8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5.3
7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5
6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0