Hi,I'm basically trying to make the pivot table values in sheet 2 (daily) turn green or red based on whether they match or not values in sheet 1 (control).I realise one method is to work the conditional formatting via formula, but can't wrap my head around it. Also not sure conditional formatting still works once new data is added and the pivot is refreshed?
Any thought, please?
sample attached.
Thanks,
Bookmarks