+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting by Row in Pivot table

  1. #1
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    380

    Conditional formatting by Row in Pivot table

    Good morning

    I have a pivot table set up comparing data week to week.

    I would like to apply conditional formatting to each row so that if an item in the row is different, highlight that cell.
    I can get the empty cells to highlight, but need anything that varies across the weeks to also highlight.

    I have tried using the above / below average rules, however they are applying to the entire table, and I cannot get them to apply to a single row of data.
    Attached is a sample where the week 1 time in row 12 is different to the other weeks.
    Attached Files Attached Files
    Handy things to keep in mind:

    Click *, if my suggestion has helped you
    If your problem is solved, then please mark the thread as SOLVED

    Sharing is Caring .... spread the knowledge

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Conditional formatting by Row in Pivot table

    is that enough for your needs?
    Attached Files Attached Files

+ 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. Replies: 1
    Last Post: 12-08-2016, 03:14 PM
  2. pivot table and conditional conditional formatting
    By Veronsito in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-07-2016, 12:15 PM
  3. Replies: 9
    Last Post: 03-07-2016, 10:39 AM
  4. Replies: 2
    Last Post: 09-04-2015, 02:47 AM
  5. Conditional formatting in a pivot table
    By pdalal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2015, 08:57 AM
  6. Pivot Table conditional formatting using VBA
    By Leonprivatemail in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2010, 08:58 AM

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