+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting for Pivot tables

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Conditional Formatting for Pivot tables

    Hello. I have months in my pivot table and years (in the row column). How can I set up conditional formatting JUST on the month values?

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Conditional Formatting for Pivot tables

    Hi,

    when on your Pivot Table you go to your rule, you get an option to select where you want to apply your rule..

    Looks like this, check it out -
    Attached Images Attached Images
    Cheers!
    Deep Dave

+ 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. Conditional Formatting Pivot Tables VBA
    By Lisa4legin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2014, 08:30 PM
  2. conditional formatting and pivot tables
    By sean1991 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-09-2013, 11:40 AM
  3. Excel 2007 : Pivot Tables and Conditional Formatting
    By tgorski31 in forum Excel General
    Replies: 1
    Last Post: 04-22-2010, 03:58 PM
  4. Conditional Formatting on pivot tables
    By KevinThomas in forum Excel General
    Replies: 2
    Last Post: 03-18-2010, 08:26 AM
  5. Conditional formatting in pivot tables
    By jmeron in forum Excel General
    Replies: 0
    Last Post: 06-11-2008, 04:34 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