Forum Discussion
ajmal_pottekattil_yoousuf
Nov 11, 2022Iron Contributor
Conditional Formatting on multiple criteria
please find the attached copy.
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.
2 Replies
- dscheikeyBronze Contributor
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.
- ajmal_pottekattil_yoousufIron ContributorThanks for the support.