Jan 31 2020 10:10 AM - edited Jan 31 2020 10:11 AM
I've attached a sample of a worksheet that I am building. I set up drop downs in a few columns with multiple selections. I am trying to figure out if there is a conditional formatting formula I can use so that each instance of a duplicate the cell becomes highlighted. So, for example, if Governing Law appears either by itself or in a string separated by commas, I want the cell to change to orange. Right now, I can only get the cell to highlight if the text is by itself.
Jan 31 2020 11:44 AM