#range object

[dataprose]

PivotTable Flash: Conditional Formatting

PivotTable Flash: Conditional Formatting

I wanted to loop through a large workbook with lots of PivotTables to set a common conditional format on the DataBodyRange of each PivotTable.

Here’s my initial PivotTable with no conditional formatting:

I would like change the text to red for any value that is less than 0.97 : [vb] Option Explicit

Sub PTConditionalFormatting()

‘Declare variables Dim wb As Workbook Dim ws As Worksheet

View On WordPress

[dataprose]

Home On The Range [Object]

  I’m a sucker for a good western. Here’s John Wayne as Rooster Cogburn in True Gritthe only film…

View Post