I want to make it so that an entire row will change color if it meets a certain criteria. Though I haven't figured out how to do it for a row, I have gotten it to change an entire column:

PivotTable.Activeview.DataAxis.FieldSets(1).Fields (0).DetailBackColor = "Blue"

In the above example it changes the whole second column to blue. I don't really know what Fields(0) does, only that if I change it, it doesen't work anymore. Does anyone know the correct syntax to change color for an entire row? Thanks.