+ Reply to Thread
Results 1 to 1 of 1

cond formating pivot table to highlight the values equal to values from diff sheet.

  1. #1
    Registered User
    Join Date
    10-20-2012
    Location
    Romania
    MS-Off Ver
    Excel 2003
    Posts
    11

    cond formating pivot table to highlight the values equal to values from diff sheet.

    Hi,I'm basically trying to make the pivot table values in sheet 2 (daily) turn green or red based on whether they match or not values in sheet 1 (control).I realise one method is to work the conditional formatting via formula, but can't wrap my head around it. Also not sure conditional formatting still works once new data is added and the pivot is refreshed?
    Any thought, please?
    sample attached.
    Thanks,
    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. To highlight source data values for a value selected in pivot table
    By hello_1234 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-22-2019, 10:43 AM
  2. non-VBA way to highlight the Top 3 values per row in a pivot table
    By bhenlee in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-23-2015, 06:53 AM
  3. Determining if Excel values equal Access table values
    By jlynn303 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-25-2014, 09:04 AM
  4. [SOLVED] Cond. Formatting - highlight cell w/value if equal value in list
    By Armitage2k in forum Excel General
    Replies: 3
    Last Post: 10-16-2012, 12:25 AM
  5. Comparing values in two columns, and highlight if not equal
    By vmc62 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-14-2008, 09:23 PM
  6. Replies: 0
    Last Post: 03-10-2006, 12:23 PM

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