Conditional formatting "text contains"
Solved
elise_forum
Posted messages
7
Status
Membre
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
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
Simply putting them in the right order was enough, I hadn't thought of that.
Have a good day!
I consider the issue resolved
safe travels
best regards