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.