Hi Forum
When I conditional format the subtotal column in a pivot table it goes and applies the same conditional format to the other columns being subtotaled.
See attached screen shot, the subtotal column for 2013 (column V) should be conditionally formatted not the other columns (columns M to T).
this conditional formatting is applied via VBA code however if i apply it manually it does the same thing.
VBA code used is as follows:
Basicly for cell V10 this is:Please Login or Register to view this content.
=IF($V$10<$L$10,TRUE,FALSE) (True being Red or down on last years)
and
=IF($V$10>$L$10,TRUE,FALSE) (True being Green or up on last years)
Once I have this working for one column i will also do similar on other columns but that is another story...
Thanks,
-Ollie
Bookmarks