• 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.

Best way to highlight differences in two sets of daily data

M

Mr M

New Member
Does anyone know the best way to highlight changes in daily data sets that are formatted the same every day?


Data is extracted from Oracle on a daily basis and dumped into a pivot table. I would like to know a cool way of highlighting the changes from day to day.


Thank you in advance for your help,

Matt
 
Assuming a basic setup where the data is aligned horizonatally (in the PivotTable?), you could do a conditional format with the formula:

=B2<>A2


and copy the formatting down as needed. If not, perhaps you could give more detail as to the exact layout of the data you want to compare.
 
You must log in or register to reply here.
Back
Top