In Excell i have one word in each cell of Colum A, I have Multiple words in each cell of Column B. I want to identify if colum A Cells text is contained in Column B Cells then either highlight Particular cells of colum A or colum B so that i can identify those cells in which Colum A one word cell is present in Colum B multiple words cell. if there is any formula through which i can highlight particular cells of Either Column A or Colum B if colum A one word Text is conatins in colum B multiple word text. Thanks and awaiting for response
incase if could not make my query clear i further explain that in colum A we have title of shope names only. and in colum B we have complete shop address alongwith shop name. i want to identify or highlight the cells of same stores in column A and Colum B. Please Help
incase if could not make my query clear i further explain that in colum A we have title of shope names only. and in colum B we have complete shop address alongwith shop name. i want to identify or highlight the cells of same stores in column A and Colum B. Please Help