title: Conditionally format Google Sheets cell based on text in a different cell
body: <p>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 <code>=IF C2 ("Yes")</code> which Google Sheets seems to accept but he result is not displayed at all.</p>