1

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?

| improve this question | | | | |
2

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

=E88="yes"  

should be sufficient, regardless of any text in D88.

| improve this answer | | | | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy