Advanced formating on pivot table cell

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.