Conditionally format Google Sheets cell based on text in a different cell

Question

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.

Answer 1

1. Select D2 (or D2:D9 or D2:<somewhere further down>)
2. Choose Format ► Conditional Formatting
3. Format cells if... Custom formula is...
           =C2="yes"
   
4. Formatting style - choose a green Fill and click Done.

5. Add new rule then repeat from step 3 with `=C2="no" and a red Fill.