topic Conditional Formatting in QlikView https://community.qlik.com/t5/QlikView/Conditional-Formatting/m-p/474506#M177201 <HTML><HEAD></HEAD><BODY><P>Can we do conditional formatting in a table in QlikView like we do in excel ?</P><P>I want to change the color of the cell based on the value of the number </P></BODY></HTML> Tue, 15 Oct 2013 21:49:59 GMT 2013-10-15T21:49:59Z Conditional Formatting https://community.qlik.com/t5/QlikView/Conditional-Formatting/m-p/474506#M177201 <HTML><HEAD></HEAD><BODY><P>Can we do conditional formatting in a table in QlikView like we do in excel ?</P><P>I want to change the color of the cell based on the value of the number </P></BODY></HTML> Tue, 15 Oct 2013 21:49:59 GMT https://community.qlik.com/t5/QlikView/Conditional-Formatting/m-p/474506#M177201 2013-10-15T21:49:59Z Re: Conditional Formatting https://community.qlik.com/t5/QlikView/Conditional-Formatting/m-p/474507#M177202 <HTML><HEAD></HEAD><BODY><P>hi Sanmaan,</P><P></P><P>You can use the visual cues found here in the Table properties,</P><P></P><P>So if a number is greater than or equal to a certain number you can format the cell background, text color and make it bold, italic etc..</P><P></P><P><IMG alt="2013-10-15_2246.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/47689_2013-10-15_2246.png" style="width: 620px; height: 513px;" /></P></BODY></HTML> Tue, 15 Oct 2013 21:58:32 GMT https://community.qlik.com/t5/QlikView/Conditional-Formatting/m-p/474507#M177202 rustyfishbones 2013-10-15T21:58:32Z Re: Conditional Formatting https://community.qlik.com/t5/QlikView/Conditional-Formatting/m-p/474508#M177203 <HTML><HEAD></HEAD><BODY><P>Hi Alan thank you so much for your prompt help. it works like a charm <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 15 Oct 2013 22:10:05 GMT https://community.qlik.com/t5/QlikView/Conditional-Formatting/m-p/474508#M177203 2013-10-15T22:10:05Z Re: Conditional Formatting https://community.qlik.com/t5/QlikView/Conditional-Formatting/m-p/474509#M177204 <HTML><HEAD></HEAD><BODY><P>Hi Alan,</P><P></P><P>its just letting me choose the upper and lower limit colour . the colour in between these 2 nos is getting shaded as lighter shade of the higher number and not the colour i choose ?</P><P></P><P>How do i work around this ?</P></BODY></HTML> Tue, 15 Oct 2013 22:16:43 GMT https://community.qlik.com/t5/QlikView/Conditional-Formatting/m-p/474509#M177204 2013-10-15T22:16:43Z Re: Conditional Formatting https://community.qlik.com/t5/QlikView/Conditional-Formatting/m-p/474510#M177205 <HTML><HEAD></HEAD><BODY><P>Hi Sanmann,</P><P></P><P>just check what numbers you are adding to the Upper and Lower as both contain =</P></BODY></HTML> Tue, 15 Oct 2013 22:20:57 GMT https://community.qlik.com/t5/QlikView/Conditional-Formatting/m-p/474510#M177205 rustyfishbones 2013-10-15T22:20:57Z Re: Conditional Formatting https://community.qlik.com/t5/QlikView/Conditional-Formatting/m-p/474511#M177206 <HTML><HEAD></HEAD><BODY><P>Yes i did. the difference in the upper level and lower level is 10</P><P></P><P>The upper level colour is Green. The lower is Red. Still numbers lower than upper level are showing in light green </P></BODY></HTML> Tue, 15 Oct 2013 22:42:05 GMT https://community.qlik.com/t5/QlikView/Conditional-Formatting/m-p/474511#M177206 2013-10-15T22:42:05Z