Conditional Formatting Custom Formula

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
1	Date Submitted	State	Gender	Age 40 and Older	Diagnosed With Any Type of Dementia	Willing to Undergo Blood Tests	Able to Comply With the Study	Able to Physically Attend the Research Site	Have a Confirmed Diagnosis of Vascular Dementia	Have Alzheimers Disease	Have Experienced Memory Impairment Since a Stroke	Have Had a Stroke or Mini Stroke in the Past	Have a History of Heart Disease	Have Had a Stent Inserted in the Heart	Have a History of High Blood Pressure	Have a History of High Cholesterol	Have Undergone MMSE	Know of MMSE Score	MMSE Score	Pregnant or Planning to Become Pregnant	Have a History of Neuropsychiatric Conditions	Have Uncontrolled Diabetes	Have Uncontrolled Hypertension	Have Uncontrolled High Cholesterol	Have Any Other Uncontrolled Chronic or Terminal Disease	Have a History of Severe Forms of Peptic Ulcers etc	Taking Any Herbs or Supplements	Willing to Refrain From Taking Herbs or Supplements	Taking Medications For Dementia or AD	Willing to Refrain From Taking Dementia Medications	Why did You Sign Up for the Trial	Referral Source	Unique ID
2	14/09/2016 15:37 pm	NSW	Male	Yes	Unsure	Unsure	Yes	Unsure	Unsure	Unsure			FALSE	FALSE	FALSE	FALSE	No				No	No	No	No	No	Unsure	No		No		used likert rating, must pass	Trialfacts	1473831457_57d8e221729074.41032274
3	14/09/2016 16:01 pm	NSW	Male	Yes	Unsure	Unsure	Unsure	Unsure	Unsure	Unsure		FALSE	FALSE	FALSE	FALSE	FALSE	No				No	No	No	No	No	No	No		No		No comments	Trialfacts	1473832913_57d8e7d141dab6.38305071
4	15/09/2016 09:59 am	NSW	Female	Yes	Yes	Yes	Yes	Yes	No	Yes		FALSE	TRUE	TRUE	TRUE	TRUE	Yes	No		No	No	No	No	No	No	No	No		No		No comments	Trialfacts	1473897541_57d9e445578f07.10047158
5	15/09/2016 10:03 am	NSW	Female	Yes	Yes	Yes	Yes	Yes	Yes								No			No	No	No	No	No	No	No	No		No		No comments	Trialfacts	1473897816_57d9e5583d9ec4.97161974
6	15/09/2016 15:51 pm	NSW	Male	Yes	Unsure	Unsure	Unsure	Yes	Unsure	Unsure		FALSE	FALSE	Unsure	FALSE	FALSE	No				No	No	No	No	No	No	No		No		Cathy's script	Trialfacts	1473918717_57da36fd94bfb8.36861332
7	15/09/2016 18:06 pm	NSW	Male	Yes	Unsure	Unsure	Unsure	Unsure	Unsure	Unsure		FALSE	FALSE	FALSE	FALSE	FALSE	No				Unsure	No	No	No	No	No	No		No		No comments	Trialfacts	1473926782_57da567ec703c8.14267123
8	16/09/2016 15:26 pm	NSW	Male	Yes	Unsure	Unsure	Unsure	Yes	Unsure	Unsure		Unsure	FALSE	FALSE	FALSE	FALSE	No				No	No	Unsure	No	No	No	No		No		No comments	Trialfacts	1474003579_57db827b499346.11377409
9	16/09/2016 16:01 pm	NSW	Male	Yes	Unsure	Unsure	Unsure	Unsure	Unsure	Unsure		FALSE	FALSE	Unsure	FALSE	Unsure	Unsure				No	No	No	No	No	No	No		No		No comments	Trialfacts	1474005661_57db8a9dd4ce83.48660380
10	16/09/2016 16:26 pm	NSW	Male	Yes	Unsure	Unsure	Unsure	Unsure	Unsure	Unsure		FALSE	FALSE	FALSE	Unsure	FALSE	No				No	No	No	No	No	No	No		No		No comments	Trialfacts	1474007201_57db90a13560e9.95625408
11	16/09/2016 17:29 pm	NSW	Male	Yes	Unsure	Unsure	Unsure	Unsure	Unsure	Unsure		FALSE	FALSE	FALSE	FALSE	FALSE	No				No	No	No	No	No	Unsure	No		No		Bankstown - slider to likert	Trialfacts	1474010960_57db9f501a1a91.85616942
12
13
14
15
16
17
18
19
20
21
22										0
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100