SOLVED

Conditional Formatting on multiple criteria

Contributor

please find the attached copy.

2 Replies
best response confirmed by ajmal pottekattil yoousuf (Contributor)
Solution

@ajmal pottekattil yoousuf 

Here is the answer. The formula must be as follows:

=AND(ISNUMBER(MATCH($B5,'Anoter Software'!$B$2:$B$7,0)),ISNA($E5))

See also enclosed sheet.

Thanks for the support.