I am trying to apply a conditional formatting to A1 if it contains a specific text (NOT it's cell value). Is there a way to type a list of the specific text to look for in another column and somehow include a search function in the conditional formula of A1? I have been stuck with this one for a while. I will also need to apply different conditional formats depending on the text contained, and for this I assume that I will need to create a different list for each format, but both the LOOKUP and FIND functions will work only if the cell VALUE of A1 matches the text found in the list, NOT if it only CONTAINS the text. If it is possible, I would appreciate any suggestions or pointers. Thanks