topic Conditional Text Color or Background based on Expression in QlikView https://community.qlik.com/t5/QlikView/Conditional-Text-Color-or-Background-based-on-Expression/m-p/389234#M562497 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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.&nbsp; The first condition is whether another field have either A, B or C - that field is called 'Target Grade'.&nbsp; </P><P></P><P>So basically:</P><P></P><P>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<BR />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<BR />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</P><P></P><P>Anyone able to get me started?</P><P></P><P>Thanks, Pri</P></BODY></HTML> Wed, 27 Feb 2013 14:51:01 GMT 2013-02-27T14:51:01Z Conditional Text Color or Background based on Expression https://community.qlik.com/t5/QlikView/Conditional-Text-Color-or-Background-based-on-Expression/m-p/389234#M562497 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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.&nbsp; The first condition is whether another field have either A, B or C - that field is called 'Target Grade'.&nbsp; </P><P></P><P>So basically:</P><P></P><P>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<BR />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<BR />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</P><P></P><P>Anyone able to get me started?</P><P></P><P>Thanks, Pri</P></BODY></HTML> Wed, 27 Feb 2013 14:51:01 GMT https://community.qlik.com/t5/QlikView/Conditional-Text-Color-or-Background-based-on-Expression/m-p/389234#M562497 2013-02-27T14:51:01Z