On Google Spreadsheet, I want cell D88 to change background color depending on the value in E88. In my head this should work like this (imagine it's a conditional formatting window):

=if(E88="yes") then format background and chose orange for range D88

Also, D88 content is yes, obviously. What am I doing wrong?

1 Answer 1


Because the formatting is Conditional you should not normally need an IF statement in the formula. Just:


should be sufficient, regardless of any text in D88.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.