ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot table -conditional formatting (color) (https://www.excelbanter.com/excel-programming/283222-pivot-table-conditional-formatting-color.html)

Nuralain

Pivot table -conditional formatting (color)
 
Hi,

Is it possible to conditionally format the color of cells
in a pivot table based on their values? I've tried
manually using conditional formatting but it's not
retained when the pivot table is changed. I'm new to VBA
and was wondering if there's a way of doing this? and any
example code available?

Thanks,

Nuralain



All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com