Advanced formating on pivot table cell

[merlino]

Hi Guys,

I'm in a bit of a pickle.

I've created a pivot table that displays the following:

[Average Result] [Competences]
[employees] [emp codes] [Result]

The result cell is c13. This field displays an integer value (1,2,3).
I have also done some conditional formatting on the cell to display the back ground colour and font colour as red.

=AND(ISNUMBER($c$13),$C$13=1)

that works all ok but now I would like to change the result to this format to:

1:L0

1 = the background colour of the cell (via the conditional formatting)
: = the delimiter
LO = the competency result.

I would like to format the cell so it shows the background colour (1 = red, 2 = amber, 3 = green) and shows the competency result in black font?

Can this be done?

I've tried as a test to see if I could get the background colour to work but it hasn't

=AND(ISNUMBER(mid($c$13, 1,1)),mid($c$13, 1,1)),=1)

Thanks in advance.

Ian.

[merlino]

Any sugguestion guys?

Thanks.

[merlino]

Hi Guys,

please let me know if I'm in the wrong forum.

Am I able to used a string in a pivot table calculation.

eg. My SP returns 1:L0

1 = Background colour
: = Dilimiter
L0 = Code value to be displayed in the cell.

Is this possible?