getpivotdata... can i access page information ?

  • Thread starter Thread starter scott23
  • Start date Start date
S

scott23

I am using a 'date range' as a page in my pivot table. So, if the
page 'date range' is true, then the pivot table is using a date range
i have elsewhere in the workbook. What id like to be able to is do a
conditional format on the results of the page. So, if the date value
is TRUE, then id like to make it a different color or make the date
range data in the workbook another color .

Any way to do this ?

Thanks
 
If you're trying to base conditional formatting on a value in a
different worksheet, you can name the cell, or link it to a cell on the
worksheet where the conditional formatting will be applied.

For example, name the cell that contains the page field, "PivotPage"

Then, select the range of cells for conditional formatting.
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type a formula that refers to the named cell, e.g.
=PivotPage>DATE(2004,4,1)
Click the Format button, and select a colour on the Patterns tab
Click OK, click OK
 
Back
Top