I have a pivot table that colours the first row to the left (This is the title or label of the expression row, not the value of the row). Im trying not to colour this cell and only colour the cell values. This is my code for the background colour on the expression.
That was nearly correct and i'm getting warmer thank , but one of my values goes into a minus and the whole row gets coloured in white... have you any other ideas as im trying to look for negative values too..
have a look. When a value goes into a minus then all goes white.
Im testing using the following code, but it still does not make the label column (far left) white or any other different colour. Ive left out the label value on the screem print for confidentiality, thanks