MarstonDemand
New Member
- Joined
- Jan 30, 2019
- Messages
- 1
Hi, I need a way of formatting cells by colour in my pivot table when the totals do not match. If you look at the example below John has a quantity of 10 while Sam has a quantity of 7. I'd like both numbers to appear red when this occurs. I'd also like the quantities to both turn green when they do match e.g. Sam has a quantity of 10 and John has a quantity of 10. Hope somebody can help. Thanks.