I am now going in circles, I tried to look for answers here but I am still stuck. I want to highlight a cell using conditional formatting if the value of that cell is present anywhere in a specific column of another sheet (row A of sheet called "Insights"). I am using this:
I tested the regex online and it seems correct, yet the cell does not get highlighted even though I know for sure that "F25" is present on that column. The cells in column A have strings like this
Any help is highly appreciated!