I am trying to use an OR statement to set off conditional formatting in google sheets, but I don't want to have to keep defining the range. In other words, I want to change the formatting if a:a100 = apple OR pear. So far, I can only see how to do it by saying or(a:a100="apple", a:a100="pear")

Your Answer

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

Browse other questions tagged or ask your own question.