I am fairly new to VB programming and need some help with writing VB code to conditionally-format the pivot table shown here (I am not inclined to use the Excel Conditional formatting option as it loses the formatting when refreshing the pivot table)
Excel_screenshot1.png
I need a VB macro that reads each value in a Pivot table .. starting with the Col1, Row1 of the Pivot table .
It then matches the value in Col 1, Row1 to the Baseline value for Col 1 that is specified in (Yellow ) .
Note : The Baseline values are not part of the Pivot table area
If the value in in the Col 1, Row1 is less than the baseline value for that column at the top ,it formats the font color of that pivot table cell (say to red)
It then moves to read the value in Col 1, Row2 and does the same check .
Once it completes the check on all values in Col 1, it does the same with Col 2 (where the values are compared to the baseline value for Col 2)
... and so on until all the colums of the PIvor table are validated in the same manner .
Thanks for reading the post .. Appreciate any help in advance !!
Bookmarks