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


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 May 31 '19 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 May 31 '19 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 May 31 '19 at 4:31
  • that is not entirely true - i.stack.imgur.com/oag4o.png – user0 May 31 '19 at 5:03

Your Answer

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

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