Hey guys,
I am trying to use conditional formatting to identify when a certain word appears in a list - "Road". I used "specific text/contains" in conditional formatting, to highlight those cells.
However, it is also highlighting words like "Broad" (B-road).
Example- in the below, I want...