I am trying to shade all rows that are associated with a specific value of column B as =$B2="BAMS", yet custom formula keeps saying the wrong formula.

Any idea?

custom formula box show error

  • 1
    on the image the first parenthesis are wrong. and also it should be B1 coz you start at A1 - i.sstatic.net/pJIWN.png
    – user0
    Commented May 31, 2019 at 3:56

1 Answer 1


try it like this:




  • 1
    thanks it worked, but why I need to start from B1, I tried B2 and it give me all row that has no BAMS
    – Kernel
    Commented May 31, 2019 at 3:59
  • @kernel now I am not sure what are you after... I got the impression that you want to color the rows that do contain BAMS. if you want opposite then the formula should be =$B1<>"BAMS" or =AND($B1<>"BAMS", B1<>"") if you want to offset it by one row then B2 is ok
    – user0
    Commented May 31, 2019 at 4:03
  • Ok. I found that if I want to color all rows with BAMS, then all B with odd number do work (B1 or B3 or B5 etc ..), but if I want to color all rows offset by one then all even number of B works (B2, or B4, ...).
    – Kernel
    Commented May 31, 2019 at 4:31
  • that is not entirely true - i.sstatic.net/oag4o.png
    – user0
    Commented May 31, 2019 at 5:03

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.