Spreadsheet: 84334d1284391287-conditional-formatting-using-formulas-as-formatting-criteria-conditional-formatting-sample
Sheet: Reps

 | Month of
 | RAE'S NAME | 1 | 2 | 4 | 5 | 6 | 7 | 8 | 9 | 11 | 12 | 13 | 14 | 15 | 16 | 18 | 19 | 20 | 21 | 22 | 23 | 25 | 26 | 27 | 28 | 29 | 30
1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 |  | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 0 |  | 0 | 0 | 1 | 1 | 0 |  | 1 | 1 | 1 | 1 | 0 |  | 1 | 1 | 0 | 1 | 0
3 |  | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1
4 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 | 1 | 1 | x | 1 |  | 0 | 0 | 0 | 1 | 1 |  | 1 | 0 | 1 | 1 | 1
5 |  | 1 | x | 0 | 0 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | x |  | x | 1 | 1 | 0 | 1 |  | 1 | 1 | 1 |  | 1
6 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 |  | 0 | 1 | 1 | 0 | 1 |  | 1 | 1 | x | x | x |  | x | 1 | 1 |  | 1
7 |  | x | 1 | 0 | 0 | 1 | 1 | 1 | 1 |  | 1 | x | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 0 |  | 1 | 0 | 0 |  | x
8 |  | 1 | x | 0 | 0 | x | x | x | 0 |  | x | x | x | x | 0 |  | 1 | 1 | x | 1 | 0 |  | 1 | 1 | 1 |  | 1
9 |  | 1 | 0 | 0 | 0 | x | 0 | 1 | 0 | 0 | x | 0 | 0 | 1 | 0 |  | x | x | 1 | x | x |  | 0 | 0 | 0 | 0 | 0
10 |  | 1 | x | 0 | 0 | x | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 1 |  | x | x | 1 | 1 | x |  | 0 | x | x |  | x
11 |  | x | 1 | 0 | 0 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 0 | x |  | 1 | 1 | x | 1 | 1 |  | 1 | 1 | 1 | 1 | 1
12 |  | 1 | x | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 |  | 1
13 |  | x | x | 0 | 0 | 1 | 1 | x | x |  | x | x | 1 | 1 | x |  | 1 | 1 | 1 | 1 | 1 |  | 1 | x | 0 | 1 | 1
14 |  | x | 1 | 0 | 0 | 0 | 1 | 1 | 1 |  | 0 | 0 | 0 | 1 | x |  | 1 | 1 | 1 | 1 | 0 |  | x | x | x |  | x
15 |  | x | x | 0 | 0 | 1 | x | x | x |  | 1 | 0 | 1 | 1 | 0 |  | 1 | 1 | 1 | 0 | x |  | 1 | x | 1 | 1 | 1
16 |  | x | x | 0 | 0 | x | 0 | 0 | 0 |  | 0 | 1 | 1 | 1 | 1 |  | x | x | x | 1 | x |  | x | x | 1 |  | x
17 |  | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |  | 1 | 1 | 1 | 1 | 1 |  | 1 | x | 1 | 0 | 0 |  | 1 | 1 | 1 | 1 | 1
18 |  | 1 | x | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1
19 |  | 1 | x | 0 | 0 | 0 | 1 | x | 1 | 0 | 1 | x | 1 | x | 1 | 0 | 1 | 1 | 1 | 1 | x |  | 1 | 1 | 1 | 1 | 1
20 |  | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | x | 1 | 1 | 1
21 |  | x | x | 0 | 0 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 0 | 1 |  | 1 | 1 | 1 | 1 | 1
22 |  | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | x | 0 | 1 | x | x | 0 | 1 | x | 1 | x |  |  | x | x | x |  | x
23 |  | x | x | 0 | 0 | 1 | 1 | 1 | 0 |  | x | 1 | x | 1 | 0 |  | 1 | 1 | 1 | x | 1 | 1 | 1 | 1 | 1 | 0 | 0
24 |  | 0 | 0 | 0 | 0 | 0 | 1 | x | 0 | 0 | 1 | 1 | 1 | 0 | 1 |  | 1 | 0 | x | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0
25 |  | x | x | 0 | 0 | 1 | 1 | x | 1 |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 0 | 1 | 1
26 |  | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 |  | 1 | 1 | 1 | 0 | 1 |  | 1 | 1 | 1 | 1 | 0 |  | 0 | 1 | 1 | 0 | 1
27 |  | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | x | 0 |  | 1 | 1 | 1 | 1 | x |  | x | x | 1 | 0 | x
28 |  | 1 | x | 0 | 1 | 0 | x | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | x |  | 1
29 |  | 1 | x | 0 | 1 | 1 | 1 | 1 | x |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 1 | 1 | 0 |  | 1 | 0 | 1 | 1 | 1
30 |  | x | x | 0 | 0 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | x | 1 |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | x | 1 | x
31 |  | 1 | x | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | x
32 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 0 |  | 1 | 1 | 1 | 0 | 0 |  | 1 | 1 | 1 | 1 | 1
33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | x |  |  |  |  | 1 | x
34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 1 |  | x | x | x | 1 | 0
35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1
36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52