Take the colours off your existing pivot table, then run the macro.