Conditional Formatting within a Pivot Table
 

Hi guys,
I am trying to change the colour of a range of cells in a column within a
pivot table depending on text content.
I have 9 different text variations, and I need to assign a colour to each
varient. For example

Ruth = Red
Andre - Blue
Melanie = Yellow
etc...

I have used a worksheet formula and it does not seem to work. Can anyone
help me?
--
crosscountrytrains.co.uk