Home/ Questions/Q 1994
In Process
Garry Christan
Asked: 2022-08-03T05:39:37+00:00

Google Sheets: Formula that checks if a specific string repeats down any number of rows between two surrounding strings?

Sample data here.

In my sheet, I mark header rows in the A-column. If all rows between any given header row are marked as “Ignore” in the B-column, then I’d like that header column to format to a different color.

How do you build a formala that can check if the string “Ignore” happens on any number of rows between two A-column cells with a given string?

(Checking for an unknown number of rows is beyond my skillset in formula-building.)

google sheetsstring
Share

1 Answer

  1. Paste this: formula in C1, to get a helper column that can be hidden.

    =AND( A1<>"", LOWER(B2)= "ignore")

    Paste this: formula in conditional formatting and set Apply to range to A1:A1000, take a look at Example Sheet

    =$B:$B="Ignore"

    enter image description here

    • 0

Leave an answer

You must login to add an answer.

Need An Account,