Conditional Formatting in Access 2003 for Pivot Tables

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

    Expert Comment

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

    Expert Comment

    by:Jeffrey Coachman
    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

    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

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

    LVL 74

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now