Forum Discussion
ajmal_pottekattil_yoousuf
Nov 11, 2022Iron Contributor
Conditional Formatting on multiple criteria
please find the attached copy.
- Nov 12, 2022
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.
dscheikey
Nov 12, 2022Bronze 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_yoousuf
Nov 13, 2022Iron Contributor
Thanks for the support.