pivot table conditional formatting

D

Dal

Hi everyone,

I've conditionally formatted a column in a pivot table so that if a date is
below or equal to today it goes red, if between 5 days before today it goes
orange and if its over today it goes green. The problem I am having is that
when I copy and paste data into the worksheet where the pivot table data is
coming from, the conditional formatting doesnt work. However, when I go to
the dates where they are pasted and I select the dates and manually write
them in again, then the conditional formatting in the pivot table works. Is
there any way to solve this?

Thanks
Dal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Dates In Excel 5
Conditional formatting on pivottable 4
conditional formatting in pivot table 1
SUM & OFFSET & PIVOT TABLE?? 0
Excel does not accept text format! 0
Excel 2007 - Pivot Table - Conditional Formatting - % of Total 1
Conditional Formatting not holding in pivot table querying Access 2

Top