11 Replies Latest reply: Nov 15, 2011 5:01 AM by Benoît Parlier RSS

    Color cell background according to field selection

      Hi QVers,

       

      I tried to find an answer in other discussions but nothing applied in my case.

       

      I have a field 'Date', and a Pivot Table used as a calendar (expression = 'Date'). But now I would like to change the background color according to the selection in the field, i.e. :

       

      if 'Date' in FieldSelection('Date'), green,

       

      else, white

       

      I can't find a way to do it without set analysis and since I ahev no aggregation, can't use it...

       

      If someone has a good idea, thanks in advance.