+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Conditional Formatting to blank a cell value in a Pivot Table

  1. #1
    Registered User
    Join Date
    10-25-2011
    Location
    Fife, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Conditional Formatting to blank a cell value in a Pivot Table

    Hi
    I hope that my request can a) be done in excel and b) that someone can show me how.

    I have built a pivot table to record scores on hierarchy based table. I have the table built and everything works fine except where the volume of responses is less than 5 I do not want it to show the score. The only way I have found to do this is to use conditional formatting to colour the cell and font the same where the responses are below 5. I can't just disregard the score as there are 4 hierarchy levels. All the scores make up the top level so need to be included. This all works fine but the problem I have is if I hover the mouse over the conditionally formatted cell a small window/box comes up next the mouse pointer and shows the name of the column, the value of the cell, the row path and the column title again. It's this that I do not want to show as it negates the conditional formatting.

    I have attached a screenshot showing the box.

    Thanks

    localpunter
    Attached Images Attached Images
    Last edited by localpunter; 10-25-2011 at 10:39 AM.

  2. #2
    Registered User
    Join Date
    10-25-2011
    Location
    Fife, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Conditional Formatting to blank a cell value in a Pivot Table

    I've manged to work it out. For anyone else who has the same issue here's how to fix it:
    Right click on any cell within the Pivot table and select Pivot Table Options and select the Display tab. Untick 'Show contextual tooltips' and click OK.
    Now if the cell is formatted not to show the cell value, when you hover the mouse pointer over the cell it won't show whats in the cell.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1