Hi again,
This forum has helped me a lot and I would like to ask to help me again.
So, I written down the formula and it works really good, it searches everything I need. But! Instead of highlighting only the cell, which contains search criteria, it's highlighting the whole row.
Here is the formula: =IF(ISBLANK(search_),0,SEARCH(search_,$A2&$B2&$C2&$D2&$E2&$F2&$G2&$I2&$J2&$K2&$L2&$M2&$N2&$O2&$P2&$Q2&$R2&$S2&$T2&$U2))
A2:U210 is my search area
Search_ is my search cell
What should I correct in order to highlight only 1 cell instead of the whole road, which contains the search criteria?
Thank you in advance
This forum has helped me a lot and I would like to ask to help me again.
So, I written down the formula and it works really good, it searches everything I need. But! Instead of highlighting only the cell, which contains search criteria, it's highlighting the whole row.
Here is the formula: =IF(ISBLANK(search_),0,SEARCH(search_,$A2&$B2&$C2&$D2&$E2&$F2&$G2&$I2&$J2&$K2&$L2&$M2&$N2&$O2&$P2&$Q2&$R2&$S2&$T2&$U2))
A2:U210 is my search area
Search_ is my search cell
What should I correct in order to highlight only 1 cell instead of the whole road, which contains the search criteria?
Thank you in advance