google sheets – Conditionally Format Non-Blank Cell in Range When Adjacent Cell on Same Row Contains Particular Value

I am trying to conditionally format the non-blank cell within a range when an adjacent cell on the same row contains a particular alpha value (ach in this instance, regardless whether ACH is written in upper case, lower case or a mix of upper/lower case).

So far I’ve tried to apply the following custom formulas to the range A2:C11:



Both formulas highlight the blank cells in the row as well as the cell populated with a value.

I’ve included a simplified example here; the result I’m actually hoping for is depicted in the image below.

conditional format range