Conditionally format a Pivot Table in a subform

  • Thread starter Thread starter nzrdb6
  • Start date Start date
N

nzrdb6

Please help! I've Googled my fingers to the bone and can't find the
answer -

I have a pivot table in a subform called PIVOT. It has 4 fields. I
need to loop thru all the values in one of the fields and turn the
text red if the condition is met.

I've tried to do this using the Access conditional formatting gui but
it doesn't seem to work for pivot table fields. Maybe it only works
using VBA.

Many thanks in advance from a tired developer!
 
Please help! I've Googled my fingers to the bone and can't find the
answer -

I have a pivot table in a subform called PIVOT. It has 4 fields. I
need to loop thru all the values in one of the fields and turn the
text red if the condition is met.

I've tried to do this using the Access conditional formatting gui but
it doesn't seem to work for pivot table fields. Maybe it only works
using VBA.

Many thanks in advance from a tired developer!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning a 3 column flat file into a "3D" Table 2
Percentages in Pivot table 2
Excel VBA For excel 0
Pivot Table Active Links 1
Can't format Pivot Table in Excel 2003 1
Can't save pivot table layout 1
Wrap Text in Access Form Pivot table 0
Conditional Formatting in Pivot Tables 3

Back
Top