As an addition to this, I've found that by using the rowno() command I can get to that information to colour accordingly.
However if I use if (rowno() > 0, "do colour here...") for some reason the pivot decides to add a row into the chart with all zeros in!! No idea why! If I take this out, that row disappears so it's definitely that "if" that's adding the row in.
Even stranger, if I do a row check for row=0 and row=1, they pick the total and the first proper row of data, completely ignoring this row in the middle - as if it doesn't exist (I wish it didn't! ).
I've also got all the blank suppress flags ticked too. So I'm left with either having coloured titles/totals or having a blank line filled with zeros at the top of my pivot - neither ideal.
Any ideas much appreciated!