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?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI 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?
=$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