• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help: Conditional Formatting in Pivot table

ETPhoneHome

New Member
Hey All, I am trying to use conditional formatting in a Pivot Table. I need to format a date column based on a True/False value in another column. I have tried to use the formula =$L1="False" (column containing the True/False value) but it is not formatting some of the dates that correspond with False. Any ideas what I am doing wrong?
I have attached the spreadsheet. Any assistance will be mostly appreciated. Thank you.
 

Attachments

  • Conditional Formatting Pivot Table.xlsx
    16.5 KB · Views: 2
Your sample isn't Pivot Table. I'd recommend you upload actual representation of your Pivot Table. It's bit hard to help without it.

Also, this forum is specifically for PowerPivot (i.e. data model based pivot table). If your data is based on regular Excel Table or Range. That should be posted in Excel forum and not in this forum.
 
Back
Top