I have the following table. I would like to do a pivot table, by Sales Rep for each month (time period), but separate it by the color (white, green, red). The reason for this is that Green Denotes that the contract is in month 1-15 and pays at one rate, whereas Red Denotes that the contract is in month 16+ which pays at a different rate.
Is this possible?
Is this possible?
Cell Formulas | ||
---|---|---|
Range | Formula | |
E3:E17 | E3 | =EDATE(D3,14) |
F3:U17 | F3 | =VLOOKUP($A3,Pivot!$A:$T,COLUMNS(Pivot!$A:B)+1,0) |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
F3:U17 | Expression | =F$2>$E3 | text | NO |
F3:U17 | Expression | =AND(F$2>=$D3,F$2<=$E3) | text | NO |