Conditional Formatting on multiple criteria

[ajmal pottekattil yoousuf]

please find the attached copy.

[#2 · Accepted 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.

[#3]

Thanks for the support.