Conditional Formatting in Excel Pivot Table Filter

Question

I have a filter field in a pivot table (Year Entered as New Freshmen). 

When Cell A1 is "TRUE", I want the value in the filter (cell D1) is changed from "(All)" to "Fall 2017".

I use a conditional formatting function, but it doesn't work. How can I fix it? 

Or is conditional formatting working in a filter of a pivot table?

Answer 1

Could you please post a picture of your Pivot Table without sensitive / confidential data? Please ensure that row numbers and column letters should be visible.

Answer 2

What sort of conditional formatting are you using?

You can add calculated columns to pivot tables. That calculated column could do the calculation you want, ie =if(a1="true", "Fall 2017", "(all)")

Here are tips with examples of calculated fields:

COUNTROWS in Excel PowerPivot August 11, 2016

https://www.myexcelonline.com/blog/using-countr...

In PowerPivot, one of the major and more powerful feature are Measures. Measures (also known as Calculated Fields in Excel 2013) are formulas/calculations that are added to a Pivot Table. We will work on a simple example to show you how easy it is to use the COUNTROWS function in your Measure. DOWNLOAD EXCEL WORKBOOK Continue Reading

This is an example worksheet:

Create Calculated Items and Fields -- A calculated field cannot check a row field’s text, e.g. IF(Type=”Yes”,Qty*1,Qty*2). Create calculated items, and multiple pivot tables, to simulate conditional formulas. PivotItemCalc.zip 14 kb 03-Aug-07

Finding Conversion ratio using Pivot Table Calculated Items http://chandoo.org/wp/2013/03/06/finding-conver...

Today, lets understand how to use Calculated items feature in Pivot tables. We will use a practical problem many of us face to learn this feature – ie calculating conversion ratio from a list of sales calls.

.

...........********************************...........

**************** BS Disclaimer **************

...........********************************...........

Standard boilerplate legalistic bafflegab disclaimer for any links to non-Microsoft websites:

The link(s) to non MS-page(s) appears to be providing accurate, safe information. I suggest you stick with the “manual” instructions. Unless I explicitly suggest it, avoid downloading their “utilities”. Thoroughly research any product advertised on the site before you decide to download and install it. Sometimes they include 3rd party programs, "unwanted" programs that are automatically installed during a standard install. So, if offered, do a "custom" install and carefully read each step. One of the steps MAY give you an option to install, or NOT, "additional" programs. 99.9% of the time you don't want to let them be installed. For example, when you install Adobe Player you are given the option of installing 2 additional "free trial" programs: Potentially Unwanted Programs: MacAfee Security Scan and MacAfee Safe Connect. The option to install is turned on, you have to manually turn it off. Those are PUP's. If you click "OK"/"Next" without paying attention you get the 2 "extra" programs.

As well, watch out for ads on the site. They may advertise products that include PUPs. Thoroughly research any product advertised on the site before you decide to download and install it.

...........********************************...........

************* End BS Disclaimer ************

...........********************************............

************ Optional Bonus Tip: Free Webinars ****************

Even if you can't participate at the scheduled times, do sign up. You can get the example file downloads AND download the recording of the session to play at a time convenient to you . They are well worth the time

************************************

Mon July 23 - Fri July 27

The 7 Steps to Getting Started with Macros & VBA -

(& actually understanding what the code means!)

With Jon Acampora, Microsoft MVP

https://www.excelcampus.com/free-macros-webinar

Answer 3

The method described here may help:

https://social.technet.microsoft.com/Forums/off...