Hi all
I have the below formula, which works "perfectly", apart from the last part of "I2="ABCDE"
The formula highlights the values in my master sheet if C2 and E2 are not in a row in Sheet6 in Columns D and Column F respectively.
However, I only want the criteria to highlight the cell, if on my master sheet in I2 is ABCDE.
Any other value ion this column, I want it to ignore the rule.
I have the below formula, which works "perfectly", apart from the last part of "I2="ABCDE"
The formula highlights the values in my master sheet if C2 and E2 are not in a row in Sheet6 in Columns D and Column F respectively.
However, I only want the criteria to highlight the cell, if on my master sheet in I2 is ABCDE.
Any other value ion this column, I want it to ignore the rule.
Excel Formula:
=ISERROR(AND(MATCH(C2,'SHEET6'!$D:$D,0),MATCH(E2,'SHEET6'!$F:$F,0),I2="ABCDE"))