Conditional Formatting in Access 2003 for Pivot Tables

Posted on 2009-02-24
Medium Priority
Last Modified: 2013-11-28
Is there anyway to do or simulate conditional formatting in access 2003 for pivot tables.
Question by:sgardner1976
  • 3
LVL 33

Expert Comment

ID: 23724062
No, you cannot do conditional formating in access pivot tables.
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 23725139
What I usually do is create queries for each of the criteria I want to Highlight.
Then you can open the query in Pivot Table view that just shows thoes values.

For example if I wanted to conditionally format all freight charges between $50 and $100 in a pivot table, I would literally make a query of all Freight orders between 50 and 100 and make a pivot table of only thoes values.
Then just open the "qry50_100" Pivot table view to see it.

Here is a simple sample.

Author Comment

ID: 23725635
Thanks, the problem is I am using it to show a schedule of equpiment on specific days and shifts, and it needs to be for multiple peices of equipment and multiple times at once.  I am trying to conditional format so that if a job is a high priority or overdue it turns color.
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 23726769

Sometimes you can create a report that simulates the Pivot Table, then you can use conditional formatting.

LVL 74

Accepted Solution

Jeffrey Coachman earned 750 total points
ID: 23728560
A CrossTab Query is basically a Pivot table.

You can creat a real table out of a crosstab query, then make a report from this table.
Then you can conditionally format this resulting Report.

Now, it takes a fair amout of work to do this, and obviously you cannot dynamically change a Report, but it does simulate a Pivot table, and you can Conditionally format it, as you requested.

Let me know if something like this is acceptable.


Screenshot attached.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question