Aeserralheiro
New Member
- Joined
- Aug 14, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi,
Is there a formula that can be applied in Conditional Formatting on a Pivot table, that confronts the available stock (field outside of pivot) with the backlog (field outside of pivot) + the demand for a certain week (inside the pivot table), if the result is negative, the demand cell should be formatted red.
Is there a formula that can be applied in Conditional Formatting on a Pivot table, that confronts the available stock (field outside of pivot) with the backlog (field outside of pivot) + the demand for a certain week (inside the pivot table), if the result is negative, the demand cell should be formatted red.