I am using Excel 2007,
I need to highlight in RED cells in a pivot table if the value in the adjacent cell is less than the referenced cell.
For any row in the Pivot Table
If Cell in column C = 0
and Cell in column D = 1
Cell in column D should be highlighted in RED.
I can't seem to figure out how to refer to the adjacent cell in a conditional format formula.
Can someone help.
I need to highlight in RED cells in a pivot table if the value in the adjacent cell is less than the referenced cell.
For any row in the Pivot Table
If Cell in column C = 0
and Cell in column D = 1
Cell in column D should be highlighted in RED.
I can't seem to figure out how to refer to the adjacent cell in a conditional format formula.
Can someone help.