Conditional formatting on cell with index match match formula

[melibop2]

I have two tabs in one excel spreadsheet. The first tab has a different participant in each row and the columns are each step in a process with a date completed or a Y/N. The second tab is the data from tab 1 pulled in and reformatted to show one patient at a time using index match match:
=INDEX('PT MPK'!B4:CZ468,MATCH('PARTICIPANT TRACKER'!B3,'PT MPK'!C4:C56,0),MATCH('PARTICIPANT TRACKER'!B5,'PT MPK'!B3:CQ3,0))

I want to conditionally format the second tab cells to highlight cells with blank result in yellow. The index match match formula is in each cell so none are technically empty.

Thanks!

 

[kevin9999]

It shouldn't matter if the cell contains a formula - you can still highlight cells that are "blank"

Book1
	A	B
1	HDR1	HDR2
2	A
3	A	A
4	B
5	B	B
6	B	B
7	A
Sheet1

Cell Formulas
Range	Formula
B2,B5:B7	B2	=IF($A2="B","B","")
B3:B4	B3	=IF($A3="A","A","")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B7	Cell	contains a blank value	text	YES

 

[melibop2]

I figured it out! My formula was actually returning a 0 for cells that had no data. Thanks!