Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kfahri342
Contributor III
Contributor III

Format Colouring for one cell - Pivot Table

Hi All,

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.

Eg. I have a months column [dimension] and only want to colour in Jan & Feb

Month

Jan

Feb
Mar
Apr

Is there a way to do this?

Many Thanks

Kozan

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

Write a background expression for Month like

= IF(Match(Month, 'Jan', 'Feb'), Green(), White())

View solution in original post

2 Replies
vishsaggi
Champion III
Champion III

Write a background expression for Month like

= IF(Match(Month, 'Jan', 'Feb'), Green(), White())

Sergey_Shuklin
Specialist
Specialist

Hello, Kozan!

Background expression is here:

backgrnd_col.png