However, it still doesn't appear to be carrying the conditional formatting down in the pivotable whenever I add new data.. Was that formula supposed to help that or was it just something to better than just manually selecting the range with the data in it?
Re: conditional formatting... things get a little trickier here given your PT's can move, expand/contract etc... (at least theoeretically), as to whether or not there's a watertight method for doing this I don't know, I'm no PT expert myself I'm afraid... the below approach is to use the VBA Pivot Table Update Event such that as the PT is refreshed the formatting is reapplied such that even rows within the DataBody Range are formatted, obviously if you have historic rows that no longer form part of the PT (ie has contracted) you may end up with legacy formatting issues (ie rows formatted that should no longer be formatted...)
(the above is set to apply only to pivottable1 - remove this test if you want the same formatting applied to any/all pivot table that is updated on the sheet)
In XL2007 things become a lot easier as the PT formatting options are significantly enhanced ... there may be a way to do likewise in the earlier versions but in truth I don't know them off hand (the styles as I recall are quite limited) - I will look around to see if I can find some good links on the subject (most likely Contextures!).
Bookmarks