I am trying to write a conditional statement that will highlight a cell in the following scenario:
Let's say cell A1 says CYDCOR BEST BUY HSP and cell B1 says Store: CYDCOR CALL CENTER - BEST BUY, cell A2 says CYDCOR BEST BUY HSP and cell B2 says StOre: CYDCOR CALL CENTER - COSTCO. I need the conditional statement to highlight cell B2 because it says CYDCOR CALL CENTER - COSTCO, not CYDCOR CALL CENTER - BEST BUY.
Bookmarks