Note: In the information hierarchy, young children tend not to inherit conditional formatting from the parent, and also the mum or dad won't inherit conditional formatting from the kids. To refresh knowledge on file open up Decide on to acquire Excel refresh PivotTable facts every time t