Format Colouring for one cell - Pivot Table

[kfahri342]

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

[vishsaggi · Accepted solution]

Write a background expression for Month like

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

[Sergey_Shuklin]

Hello, Kozan!

Background expression is here: