Need to exclude formatting from pivot subtotals

[Michael_Reese]

I am trying to format cells in a pivot table, but I want to ignore the subtotals. 

Ex, the three salmon columns should have no formatting like the top row.

The formula shown works for the top row, but not the pivoted dimensions.

Thanks!

[Michael_Reese · Accepted solution]

Here it is:

Basically, dimensionality takes care of the top totals row (rows dimension).  ColumnNo’s 0,-1, and -2 take care of pivoted column totals.  I'm conditionally showing Start Date, with a different format.

if([SP Completed Date]>0 and dimensionality()<>0 and match(ColumnNo(),0,-1,-2)=0,rgb(255,255,215),
       if(dimensionality()<>0 and match(ColumnNo(),0,-1,-2)=0 and [SP Start Date]>0, rgb(255,206,206))
       )