Conditional Formatting between two tables

[gheyman]

I have two tables on the same sheet. The first the user populates with part numbers the second uses Power Query to pull in additional information about the parts on the first list.

If there is no additional data, that part does not appear in the second table

I would like to have some kind of conditional formatting on the first table. If there is a part number on the first table but its not in the second table I want to make the cell formatted in some way (maybe make it red...)

Is this possible since its two separate tables?

 

[etaf]

Not sure i fully understand how it looks

should be able to use a countif()
BUT as i'm on a mac cant use powerQuery


=Countif(TABLE2 - Part ID range ,Table1 Part ID)=0

Book5
	A	B	C	D	E	F	G	H	I	J
1	TABLE1						Table2
2	Part Number						Part Number
3	1						1
4	2						4
5	3						5
6	4						6
7	5						7
8	6						8
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:D8	Expression	=COUNTIF($G$3:$G$8,$A3)=0	text	NO