Format column in PIVOT table

[programerAnel]

To create pivot table i use

xlBook.ActiveSheet.PivotTableWizard(Excel.XlPivotTableSourceType.xlDatabase, xlSheet.Range("A1:D" & ukupno))
xlBook.ActiveSheet.PivotTables(1).PivotFields("Poslovna jedinica").Orientation = Excel.XlPivotFieldOrientation.xlRowField
xlBook.ActiveSheet.PivotTables(1).PivotFields("Opština").Orientation = Excel.XlPivotFieldOrientation.xlColumnField

xlBook.ActiveSheet.PivotTables(1).PivotFields("Neto").Orientation = Excel.XlPivotFieldOrientation.xlDataField
xlBook.ActiveSheet.PivotTables(1).PivotFields("Number of workers").Orientation = Excel.XlPivotFieldOrientation.xlDataField

After that i need to format the column "Neto" to

.NumberFormat = "#,##0.00_);[Red](#,##0.00)"

The point is if i use like this

xlBook.Worksheets("Pivot").Range("C:F").NumberFormat = "#,##0.00_);[Red](#,##0.00)"

it will format the column "Number of workers" as well which i don't want to

How to format only column "Neto" or as many exist, because it can be from 1 to n

 

[programerAnel]

I managed to work it out.

xlBook.Worksheets("Pivot").PivotTables(1).PivotSelect("Sum of Neto", Excel.XlPTSelectionMode.xlDataOnly)
Dim MySelection As Excel.Range = xlApp.Selection
MySelection.NumberFormat = "#,##0.00_);[Red](#,##0.00)"
MySelection.HorizontalAlignment = Excel.Constants.xlRight