duplicate text in one cell

  1. B

    Excel Conditional Format if text appears twice in one cell

    Hello. Would anyone know how to use conditional format when the same word appears twice in one cell? In the example below, A1:A4 A1 apple A2 apple, banana A3 apple, apple, banana A4 apple, apple one cells A3 and A4 should be highlighted using conditional format