I would like to format cell D2 based on text in C2. I would like D2 to be colored Red if C2 contains text from a drop down of "No" and be colored Green if the text is "Yes". I have tried custom formula containing `=IF C2 ("Yes")` which Google Sheets seems to accept but he result is not displayed at all.