Conditional Formatting - 4 Conditions

[Katich]

Hello,

I have a file that I've created formatting for that seems to work except on my last condition. As you can see, in C8, i have n/a. Well, when that occurs i want those cells to have no format. However, they are green because they equal my one condition. The n/a is manually added, not a formula. I have the "No Format" condition referencing A4 which i thought i could put in "N/A" in that cell and just have it look at that and see if i could get it to work. That is why that is different from the others. Any ideas? This may be simple as i'm not good at conditional formatting at all. haha

Thank you,

 

[Katich]

I meant to post this

Combined Roll Up June 2022 - Rolling 12 7-8-22.xlsx
	A	B	C	D	E	F	G	H	I	J
1
2
3
4
5			Rolling 12 Results
6	PT Metric Code	PT Metric Weight	PT Result	PT 75th %	PT 90th %	AC Metric Code	AC Metric Weight	AC Result	AC 75th %	AC 90th %
7	BCS	$$	83%	82%	84%	BCS	$$$	80%	78%	83%
8	CVC	n/a		n/a	n/a	CVC	$$	81%	78%	83%
9	CCS	$$	82%	86%	90%	CCS	$$	68%	79%	83%
10	FLU	$	70%	76%	79%	FLU	n/a		n/a	n/a
11	PNU	$	93%	95%	98%	PNU	n/a	n/a	n/a	n/a
12	HTN	$$$	82%	82%	86%	HTN	$$$	78%	76%	80%
Summary (all measures)

Cell Formulas
Range	Formula
C7	C7	='PTHP by Office for OpX'!$C37
D7	D7	='PTHP by Office for OpX'!$C38
E7	E7	='PTHP by Office for OpX'!$C39
H7	H7	='AC by Office'!$C37
I7	I7	='AC by Office'!$C38
J7	J7	='AC by Office'!$C39
H8	H8	='AC by Office'!$E37
I8	I8	='AC by Office'!$E38
J8	J8	='AC by Office'!$E39
H9	H9	='AC by Office'!$G37
I9	I9	='AC by Office'!$G38
J9	J9	='AC by Office'!$G39
C9	C9	='PTHP by Office for OpX'!$E37
D9	D9	='PTHP by Office for OpX'!$E38
E9	E9	='PTHP by Office for OpX'!$E39
C10	C10	='PTHP by Office for OpX'!$G37
D10	D10	='PTHP by Office for OpX'!$G38
E10	E10	='PTHP by Office for OpX'!$G39
C11	C11	='PTHP by Office for OpX'!$I37
D11	D11	='PTHP by Office for OpX'!$I38
E11	E11	='PTHP by Office for OpX'!$I39
C12	C12	='PTHP by Office for OpX'!$K37
D12	D12	='PTHP by Office for OpX'!$K38
E12	E12	='PTHP by Office for OpX'!$K39
H12	H12	='AC by Office'!$I37
I12	I12	='AC by Office'!$I38
J12	J12	='AC by Office'!$I39

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F8:H22	Expression	=$H8=$A$4	text	YES
F8:H22	Expression	=$H8<$I8	text	NO
F8:H22	Expression	=$H8>=$J8	text	NO
F8:H22	Expression	=$H8>=$I8	text	NO
A8:C22	Expression	=$C8=$A$4	text	YES
A8:C22	Expression	=$C8<$D8	text	NO
A8:C22	Expression	=$C8>=$E8	text	NO
A8:C22	Expression	=$C8>=$D8	text	NO
F7:H7	Expression	=$H7=$A$4	text	YES
F7:H7	Expression	=$H7<$I7	text	NO
F7:H7	Expression	=$H7>=$J7	text	NO
F7:H7	Expression	=$H7>=$I7	text	NO
A7:C7	Expression	=$C7=$A$4	text	YES
A7:C7	Expression	=$C7<$D7	text	NO
A7:C7	Expression	=$C7>=$E7	text	NO
A7:C7	Expression	=$C7>=$D7	text	NO