topic Re: Format Colouring for one cell - Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Format-Colouring-for-one-cell-Pivot-Table/m-p/1335897#M412072 <HTML><HEAD></HEAD><BODY><P>Hello, Kozan!</P><P></P><P>Background expression is here:</P><P><IMG alt="backgrnd_col.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167673_backgrnd_col.png" style="height: 518px; width: 620px;" /></P></BODY></HTML> Wed, 21 Jun 2017 16:24:43 GMT Sergey_Shuklin 2017-06-21T16:24:43Z Format Colouring for one cell - Pivot Table https://community.qlik.com/t5/QlikView/Format-Colouring-for-one-cell-Pivot-Table/m-p/1335895#M412070 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a pivot table, and I need to colour in only specific cells. The only way I have figured out colouring cells is by right-clicking and going on Custom Format Cell. But this method colours the entire dimension, rather than a specific value within that dimension.</P><P></P><P>Eg. I have a months column [dimension] and only want to colour in Jan &amp; Feb</P><TABLE border="1" class="jiveBorder" height="140" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 76px; height: 142px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>Month</STRONG></P><P></P></TH></TR><TR><TD style="padding: 2px;"><P>Jan</P></TD></TR><TR><TD style="padding: 2px;">Feb</TD></TR><TR><TD style="padding: 2px;">Mar</TD></TR><TR><TD style="padding: 2px;">Apr</TD></TR></TBODY></TABLE><P></P><P></P><P>Is there a way to do this?</P><P></P><P>Many Thanks</P><P>Kozan</P></BODY></HTML> Wed, 21 Jun 2017 15:59:16 GMT https://community.qlik.com/t5/QlikView/Format-Colouring-for-one-cell-Pivot-Table/m-p/1335895#M412070 kfahri342 2017-06-21T15:59:16Z Re: Format Colouring for one cell - Pivot Table https://community.qlik.com/t5/QlikView/Format-Colouring-for-one-cell-Pivot-Table/m-p/1335896#M412071 <HTML><HEAD></HEAD><BODY><P>Write a background expression for Month like</P><P></P><P>= IF(Match(Month, 'Jan', 'Feb'), Green(), White())</P></BODY></HTML> Wed, 21 Jun 2017 16:01:56 GMT https://community.qlik.com/t5/QlikView/Format-Colouring-for-one-cell-Pivot-Table/m-p/1335896#M412071 vishsaggi 2017-06-21T16:01:56Z Re: Format Colouring for one cell - Pivot Table https://community.qlik.com/t5/QlikView/Format-Colouring-for-one-cell-Pivot-Table/m-p/1335897#M412072 <HTML><HEAD></HEAD><BODY><P>Hello, Kozan!</P><P></P><P>Background expression is here:</P><P><IMG alt="backgrnd_col.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167673_backgrnd_col.png" style="height: 518px; width: 620px;" /></P></BODY></HTML> Wed, 21 Jun 2017 16:24:43 GMT https://community.qlik.com/t5/QlikView/Format-Colouring-for-one-cell-Pivot-Table/m-p/1335897#M412072 Sergey_Shuklin 2017-06-21T16:24:43Z