Forum Discussion

Copper Contributor

Nov 08, 2023

Pivot table conditional formatting with formula

Hello! I want to format my pivot table so if the value of the previous column is different to "0" (in that case background is red) change the background color to yellow. I upload an image so it is ea...

excel

Lorenzo

Silver Contributor

Nov 11, 2023

Hi danisp04

The main idea is to colour in yellow the next 4 months after a red cell and then they are green until a red appears again

If the above picture reflects what you expect this sounds doable. If it doesn't could you post a few examples to clarify things?