E
Edmund Seet
One way:
In A2, Cond Format | Formula is:
=SEARCH("Discounted",A2,1)>0
When Excel finds the word "Discounted" within the
string "ABC90 (Discounted)", it will return as true.
This may not be the best way but I hope it can help a
little.
Edmund Seet
In A2, Cond Format | Formula is:
=SEARCH("Discounted",A2,1)>0
When Excel finds the word "Discounted" within the
string "ABC90 (Discounted)", it will return as true.
This may not be the best way but I hope it can help a
little.
Edmund Seet