Exlude Pivot Table Sub-Total From Conditional Format

[brent_milne]

Is there a way to conditional format a column in a pivot table but not include the subtotal cell? I am thinking I would test for the word 'Total' in column A and if it is found then don't perform the formatting. I am not sure how to test for 2 conditions in the formula so any help is greatly appreciated.

 

[DanteAmor]

To your condition add the part of the LEFT () function

=AND(D3<>"",LEFT(D3,5)<>"Total")