0 Replies Latest reply: Feb 27, 2013 9:51 AM by prisandhu RSS

    Conditional Text Color or Background based on Expression

      Hi All,

       

      I've got a couple of date fields like 'Last Meeting', 'Last Phone Call' etc that i'm trying to have coloured based on conditions.  The first condition is whether another field have either A, B or C - that field is called 'Target Grade'. 

       

      So basically:

       

      If the 'Target Grade' field = 'A' and the 'Last Meeting' or 'Last Phone Call' date is greater than 3 months I would like the date values to turn Red
      If the 'Target Grade' field = 'B' and the 'Last Meeting' or 'Last Phone Call' date is greater than 6 months I would like the date values to turn Red
      If the 'Target Grade' field = 'C' and the 'Last Meeting' or 'Last Phone Call' date is greater than 12 months I would like the date values to turn Red

       

      Anyone able to get me started?

       

      Thanks, Pri