Building on a question I asked here, I am trying to conditionally format the non-blank cell within a range when an adjacent cell on the same row contains either or both of two specific values ("ach" and/or "wire").
So far I've tried to apply the following custom formulas to the range
The above formula highlights the entire row from columns
A:C if the cell on the same row in column
D contains either ach, wire or both of these values. This is close, but I need only the non-blank cell on the row to be highlighted.
This formula does the same as the first; additionally it highlights the non-blank cells on the rows where column
D does not contain either of the searched-for values (ach or wire).
I've included a simplified example here; the result I'm actually hoping for is depicted in the image below.