I have the below formula to conditional format a cell (E72) as highlighted if true, HOWEVER, if cells E57 or E68 contain "yes" and the conditions for E58 or E66 are satisfied, nothing is happening to cell E72. Oddly, if cell E59 is set to "yes" and either E58 contains "yes" or E66 contains "r", the target cell (E72) is highlighting as expecting! Please help?
=AND(OR(ISNUMBER(SEARCH("Yes",$E$58)),ISNUMBER(SEARCH("r",$E$66))),OR(ISNUMBER(SEARCH("Yes",$E$57)),ISNUMBER(SEARCH(“Yes”,$E$59)),ISNUMBER(SEARCH("Yes",$E$67)),ISNUMBER(SEARCH(“Yes”,$E$68))))
Bookmarks