hellfire45
Active Member
- Joined
- Jun 7, 2014
- Messages
- 462
I have a table with about a dozen columns on it and maybe 200 rows.
Each cell has 2 custom formulas for conditional formatting (As seen below). In the below formulas the N26 refers to the cell in the aforementioned table that the conditional formatting is going. And the Z26 and $Y26 are formulas off to the side, not on the table, that are calc'ing things that I want the conditional formatting formula referencing. However, when I format paint the conditional formatting, these below formulas do not behave as normal formulas would with the locking references. For example, column T in the table will ultimately end up with the CF formula =IF(AND(S26<0,AE26>0),TRUE,FALSE) when I expect =IF(AND(T26<0,AF26>0) This type of issue seems to occur not only on the column references but the row ones as well. So if I drag down to row 30 for instance, the formula might still display row 26. What the heck is happening here? It's killing me.
Conditional Formatting Examples:
=IF(AND(N26<0,Z26>0),TRUE,FALSE)
=IF(AND(N26>1,$Y26=1),TRUE,FALSE)
Each cell has 2 custom formulas for conditional formatting (As seen below). In the below formulas the N26 refers to the cell in the aforementioned table that the conditional formatting is going. And the Z26 and $Y26 are formulas off to the side, not on the table, that are calc'ing things that I want the conditional formatting formula referencing. However, when I format paint the conditional formatting, these below formulas do not behave as normal formulas would with the locking references. For example, column T in the table will ultimately end up with the CF formula =IF(AND(S26<0,AE26>0),TRUE,FALSE) when I expect =IF(AND(T26<0,AF26>0) This type of issue seems to occur not only on the column references but the row ones as well. So if I drag down to row 30 for instance, the formula might still display row 26. What the heck is happening here? It's killing me.
Conditional Formatting Examples:
=IF(AND(N26<0,Z26>0),TRUE,FALSE)
=IF(AND(N26>1,$Y26=1),TRUE,FALSE)