+ Reply to Thread
Results 1 to 3 of 3

Formulas Changing in Conditional Formatting After Pivot Refresh

  1. 03-27-2024, 01:47 PM #1
    idkcy
    idkcy is offline
    Registered User
    Join Date
    03-27-2024
    Location
    Los Angeles
    MS-Off Ver
    2402
    Posts
    1

    Angry Formulas Changing in Conditional Formatting After Pivot Refresh

    I added a formula to highlight two cells if the condition is not met. When I refresh the pivot the second column is unhighlighting and when I check the ranges I see that it stops being absolute and duplicates and adds a new range. Basically when column C or D doesn't meet the condition then it should highlight the cell along with the cell in the same row under column A.

    I added an example of how the range should look like vs how it looks after a refresh.

    Screenshot 2024-03-20 163426.png
    Screenshot 2024-03-20 163238.png
    Reply With QuoteRegister To Reply
  2. 03-28-2024, 03:14 AM #2
    josephteh
    josephteh is offline
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,059

    Re: Formulas Changing in Conditional Formatting After Pivot Refresh

    Welcome to the forum. Please see yellow banner at the top on how to attach a sample workbook.
    Reply With QuoteRegister To Reply
  3. 03-28-2024, 03:18 AM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Formulas Changing in Conditional Formatting After Pivot Refresh

    Administrative Note:

    Welcome to the forum.

    Please provide a workbook.

    Is your forum profile showing the Excel PRODUCT that you need this to work for?

    Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

    The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

    Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting Pivot Table When A Value Changes on Refresh
    By smithgg63 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-20-2016, 09:06 AM
  2. [SOLVED] Pivot Table Conditional Formatting and Formulas
    By eguirocker3 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-08-2016, 12:47 PM
  3. Pivot columns conditional formatting not saved after refresh
    By moty.98 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-28-2013, 10:59 AM
  4. Formulas for conditional formatting in pivot table
    By artefarct in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-19-2013, 01:04 AM
  5. Conditional icon formatting in pivot excel 2010 to stay with refresh
    By newbieexcelgirl in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-19-2012, 04:22 PM
  6. [SOLVED] changing formulas in conditional formatting
    By davidrose in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-14-2012, 02:17 PM
  7. changing IF formulas to Conditional formatting?
    By excel_soldier in forum Excel General
    Replies: 6
    Last Post: 06-06-2012, 04:53 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1