I have this Pivot Table, and what I need to do is: Filter this data and show only those records whose date (3rd column) is equal to its parent date (2nd column) or just 1 day difference is there.
And then I have to put conditional formatting on the values (Columns after 3rd column) based on 'If both dates are same and the value lies in particular column'
How to do that? Currently I have to do it manually, so looking for a solution if anyone could help. Thanks in advance