Hey All,
I have been having some problems with some conditional formatting.
I have columns showing Foretasted Spend vs Actual Spend (Starting with D:E and going down and across)
What I am after, is comparing 2 things:
Now i have the below formula that works in a cell but doesn't seem to work in the conditional formatting.
Cross post Here: https://www.excelforum.com/excel-fo...matting-in-pairs-not-working.html#post4763509</offset(d6,0,1-mod(column(d6),2)))[>
I have been having some problems with some conditional formatting.
I have columns showing Foretasted Spend vs Actual Spend (Starting with D:E and going down and across)
What I am after, is comparing 2 things:
- Weather the Forecast is more than a Actual By a certain Percentage shown in [A3] (i have it at 20%, so an if forecast was 500 then the cell will turn red for anything less than an actual of 400)
- If the Forecast is lower than actual.(So if forecast is 500, an actual of 501 would turn the cell red too)
Now i have the below formula that works in a cell but doesn't seem to work in the conditional formatting.
Code:
=OR(OFFSET(D6,0,-MOD(COLUMN(D6),2))*(1-$A$3)>OFFSET(D6,0,1-MOD(COLUMN(D6),2)),OFFSET(D6,0,-MOD(COLUMN(D6),2))<offset(d6,0,1-mod(column(d6),2)))[ code]<font="" color="#333333">
Cross post Here: https://www.excelforum.com/excel-fo...matting-in-pairs-not-working.html#post4763509</offset(d6,0,1-mod(column(d6),2)))[>
Last edited: