changing cell colors in a pivot table?

[Atomsk]

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.

 

[llkhoutx]

One solution is to use the "Cditional Fomatting..." available by right clicking a control in the design view.

 

[Atomsk]

Unfortunately, I don't seem to have one of those (this is a data access page).