Conditional formatting "text contains"
Solved
-
Hello,
I have several product references in my file, and the goal is that each time a reference is written, the cell colors according to the corresponding color (each reference has a different color).
However, I have the following problem: I have two similar references, one that starts with the same beginning as the other:
- Z101
- Z101N
The color of Z101 automatically applies to Z101N, and I can't differentiate them.
Do you have a solution that would block part of the text or anything else?
Thank you in advance,
Elise
I have several product references in my file, and the goal is that each time a reference is written, the cell colors according to the corresponding color (each reference has a different color).
However, I have the following problem: I have two similar references, one that starts with the same beginning as the other:
- Z101
- Z101N
The color of Z101 automatically applies to Z101N, and I can't differentiate them.
Do you have a solution that would block part of the text or anything else?
Thank you in advance,
Elise
