Results 1 to 4 of 4

Highlighting the pivot table row based on criteria

Threaded View

paradise2sr Highlighting the pivot table... 01-30-2021, 04:29 AM
Bo_Ry Re: Highlighting the pivot... 01-30-2021, 06:56 AM
paradise2sr Re: Highlighting the pivot... 01-30-2021, 11:08 PM
JeteMc Re: Highlighting the pivot... 02-03-2021, 03:16 PM
  1. 01-30-2021, 04:29 AM #1
    paradise2sr is offline
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2024
    Posts
    1,426

    Highlighting the pivot table row based on criteria

    Hi,

    I have a pivot table which I want to highlight row based on criteria which if Column L6 & Below is >0,then it should highlight the entire row as shown in attachment which is in hardcoded in sample format.Every now and then I have to add or modify data as well.

    Hence,expecting the desired result.
    Attached Files Attached Files
    Last edited by paradise2sr; 01-30-2021 at 04:33 AM.
    Reply With QuoteRegister To Reply
« 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. VBA Selecting Items in Pivot table filter based on criteria
    By YuriyBaron in forum Excel General
    Replies: 5
    Last Post: 05-02-2018, 12:07 PM
  2. Fill Color in pivot table based on criteria in data
    By mihir_joshi01 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-11-2015, 04:44 AM
  3. Hide pivot table columns based on date criteria
    By boontz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-16-2014, 09:56 AM
  4. [SOLVED] Pivot table criteria based on Cell value
    By cmb80 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-27-2014, 07:26 AM
  5. [SOLVED] sum data in pivot table based on date criteria
    By joeycrak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-23-2013, 09:45 AM
  6. Get a sum of values based on certain criteria from the dymanically changing pivot table.
    By kasavego70 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-26-2012, 08:18 AM
  7. Concatenate Pivot Table fields based on criteria
    By dluhut in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2012, 12:52 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1