samibo
New Member
- Joined
- Feb 11, 2011
- Messages
- 49
Excel 2010 Pivot Table.
10 columns of data which I have setup with Conditional formatting to change colour of the cells.
Cell alignment set as centered
Within Pivot Table Options I have Preserve cell formatting on update ticked.
When I refresh the pivot the conditional formatting works but the text aligns to the right.
How do I get the text to stay centrally aligned to the centre of each column?
Any advice appreciated.
10 columns of data which I have setup with Conditional formatting to change colour of the cells.
Cell alignment set as centered
Within Pivot Table Options I have Preserve cell formatting on update ticked.
When I refresh the pivot the conditional formatting works but the text aligns to the right.
How do I get the text to stay centrally aligned to the centre of each column?
Any advice appreciated.
