+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting rows in Pivot Table HELP!

  1. #1
    Registered User
    Join Date
    03-10-2014
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    42

    Conditional Formatting rows in Pivot Table HELP!

    Hi All,

    I have a pivot table which shows below... I need to set up a conditional format to highlight the row where all fields are "0"

    Company Deals Opps Days since Deal Days since Opp Days since Meet
    Co 1 1 7 80 20 20
    Co 2 0 0 0 0 0
    Co 3 1 4 30 30 28
    Co 4 3 3 30 30 37

    Any suggestions on how I would do that, would be greatly appreciated!

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Conditional Formatting rows in Pivot Table HELP!

    You can use conditional formatting in a pivot table just the same as you use it in any other worksheet. Before setting up the conditional formatting right click on the pivot table and select Pivot Table Options then tick "Preserve cell formatting on update". Click OK to save the change.

    Good luck with it.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot table & conditional formatting maybe???
    By thursday140 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-07-2013, 02:48 PM
  2. Conditional Formatting in Pivot Table
    By kimberlyre2000 in forum Excel General
    Replies: 0
    Last Post: 12-04-2012, 03:15 PM
  3. [SOLVED] Pivot Table - Conditional Formatting
    By lewny1983 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2012, 04:51 AM
  4. Conditional Formatting a pivot table
    By thestappa in forum Excel General
    Replies: 0
    Last Post: 09-01-2010, 04:04 PM
  5. Pivot Table Conditional Formatting
    By iaaw100aes in forum Excel General
    Replies: 1
    Last Post: 12-02-2008, 01:05 PM

Tags for this Thread

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