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?

migrated from superuser.com Feb 15 '14 at 5:55

This question came from our site for computer enthusiasts and power users.

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.

Your Answer

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