Hello !
I am trying to use conditional formatting with multiple text criteria. All the cells of my table include different words in this format : "XXX; YYY; VVV, WWW".
I would like, with one conditional formatting formula, to be able to highlight the cells containing "XXX" and "YYY", that are amongst the other words, in all the cells of one column, but I can't really find a formula to do it.
For example, the word "acanthe" needs to be found in the 3 cells : "Acanthe", "Acanthe à feuilles molles" and "Acanthe épineuse".
I here attach an example of a table, in wish to search for the words "Abutilon, Acanthe, Achillée, Aconit, Adonis, Ail, Alchémille, Anémone" amongst the cells of column "C".
Do you think you could help me ?
Thanks a lot++
(sorry, I had forgotten the attached table)
Bookmarks