7 Replies Latest reply on Sep 4, 2018 7:38 AM by Matt Townend

    Calculation Formula to Highlight Certain Data

    Matt Townend

      Hi,

       

      Can anyone help me out with this problem?

       

      I want to highlight the rows of data where 2 or more countries appear on the same day. So in the example below, I want to highlight both rows for the 5th July 2018 as both United Kingdom and the United States appears.

       

      Also, if I could also get help coming up with a calculation that would highlight where the countries are the same but the cities are different on the same day?

      Any help would be really appreciated.

       

      Cheers,

      Matt