Hiya All,
I have the following formula set in Conditional formatting to highlight the entire row when the town Aston is present.
The issue I have is it also highlights cells that contain words with "aston" in them i.e. Glastonbury.
Is there a way to stop this?
Thanks in Advance!![Smile :-) :-)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I have the following formula set in Conditional formatting to highlight the entire row when the town Aston is present.
Excel Formula:
=SEARCH("Aston",$G1)
The issue I have is it also highlights cells that contain words with "aston" in them i.e. Glastonbury.
Is there a way to stop this?
Thanks in Advance!
![Smile :-) :-)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)