7 Replies Latest reply on Jul 26, 2017 8:28 PM by fitch

    PortalTool mark cells with equal value in different color


      I have a Portal that shows me price offers from dealers. So I did sort after price and item_nr.


      So that looks like this


      Dealer     Item     Nr      Price

      D1          ABC     123     8,2

      D2          ABC     123     9,5

      D3          ABC     123     10,2

      D1          DEF     234     8

      D2          DEF     234     11

      D3          DEF     234     12


      Now I want to mark euqal items with a Color (in this example red and blue).

      Its clear that I use ConditionalFormating, but how can I programm it so that it uses dynmaically colors for each bunch of same items.

      I could use for example 20 different entrys in the ConditionalFormating calculation but what if I have 21 different products.

      Thats just not really elegant.


      Any workarround?


      Also one question about sorting.


      I never get the exakt sorting as in the table abouve. Eeven i use the Price as first entry in the sorting option, but then the 4. Line would be on place second. or i use the ItemNr and then its not sorting the Prives right.