Conditional Format - highlight if certain criteria in sheet 4 met, but is not in sheet 6

[surkdidat]

Hi all

Thanks in advance for everyone's continuous help on this forum!

What I am after is some conditional formatting on Tab 4 that will highlight the value in that row (Column E) IF its is a TYPE_1, and the value and code is NOT on Tab 6,

So, in Tab 4, for example, I would need the first row to highlight the value (Colour) if the code (12345) and Value (Colour) is NOT on Tab 6.

So, the rule only applies to anything that is a TYPE_1 (Column I)
Row 1 would NOT need to be highlighted as the code (12345) and Value (Colour) appear in Tab 6
Row 2 would NOT need to be highlighted as a TYPE_2
Row 3 WOULD need to be highlighted, as it is a TYPE_1 but the code (12345) and Value (Country) do not appear on any row in Tab 6

I hope that makes sense
(The "Breed" on Tab 6 is just an example that other data may appear in Tab 6 that does NOT need to be in Tab 4, or highlighted)

	Column A	Column B	Column C	Column D	Column E	Column F	Column G	Column H	Column I
			Code	CodeName	Value				Type
Row 1			12345	Horses	Colour				TYPE_1
Row 2			12345	Horses	Size				TYPE_2
			12345	Horses	Country				TYPE_1

TAB 6

	Column A	Column B	Column C	Column D	Column E	Column F
				Code	CodeName	Value
				12345	Horses	Colour
				12345	Horses	Breed

 

[surkdidat]

** {PLEASE IGNORE - I HAVE WORKED OUT THE SOLUTION **)

=ISERROR(AND(MATCH(C2,'TAB6'!$D:$D,0),MATCH(E2,'TAB6'!$F:$F,0),I2="TYPE1"))