Hi every one again
Can any one help on following condition;
I have few cells, lets say C2 and C3:C10
I need a conditional format that can colour any cell between C3:C10 if any of these cell matching with C2
Ex -
C2 may contain Chunk in water 185g , while
C7 contain Tuna chunks in water 185g
the condition should be able to match any unique word (2 word and 1 word) between these cells (C2 , C3:C10) and color the particular cell (C3:C10) (other wise you can suggest if condition like, if any of these word (matching) true , return 1 or 0)
unique word (2 word and 1 word)
A formula to find two unique word and one unique word
I'm just wounding whether excel has this option
Thanks in advance
Can any one help on following condition;
I have few cells, lets say C2 and C3:C10
I need a conditional format that can colour any cell between C3:C10 if any of these cell matching with C2
Ex -
C2 may contain Chunk in water 185g , while
C7 contain Tuna chunks in water 185g
the condition should be able to match any unique word (2 word and 1 word) between these cells (C2 , C3:C10) and color the particular cell (C3:C10) (other wise you can suggest if condition like, if any of these word (matching) true , return 1 or 0)
unique word (2 word and 1 word)
A formula to find two unique word and one unique word
I'm just wounding whether excel has this option
Thanks in advance
