Home/ Questions/Q 6403
Next
In Process
Computing Staff
  • 10
Asked: 2021-11-19T05:41:57+00:00 In:

Multiple Conditional Formatting For Pivot Tables

  • 10

I am working in a pivot table within excel 2010. There are three columns I am working with, 2 of which are dates, the third is a column with a number. I am trying to find the difference between the first two dates and if the difference is larger than the third column with the number, I would like to format it a certain way within the conditional formatting options. The true issue is that every formula I know, gets messed up when the pivot table changes. I need something that stays consistent within the pivot table’s data changes.

Share

    1 Answer

    1. Okay – so we need to see how the access table is formatted. The field for the translation must be Numerical. Can you change the Access table?

      Also – is the Pivot done in Access or are you importing the tables into Excel?
      never mind – I just saw your first line of your first post.

      But we should look at how you are getting the information from Access to Excel.

      • 0