A
Allenx
I'm trying to understand why conditional formatting formulas adjust
their address references differently then formuals in cells.
Example....
Assume the contents of G30 = 5
The following three conditional format equations
=SUM(G$35:G35)>=G$30
=SUM(G$35:G35)>=G30
=SUM(G$35:G35)>=5
Adjust differently when a new row 32 is inserted. When
I insert this row....
EXCEL automatically changes the first two equation to
=SUM(G$1:G35)>=G$30 and
=SUM(G$1:G35)>=G30
While the third equation adjusts to what I want, (and see when
the same formula is used in a normal cell).
=SUM(G$36:G36)>=G$30
Can anyone explain why EXCEL is doing this?
their address references differently then formuals in cells.
Example....
Assume the contents of G30 = 5
The following three conditional format equations
=SUM(G$35:G35)>=G$30
=SUM(G$35:G35)>=G30
=SUM(G$35:G35)>=5
Adjust differently when a new row 32 is inserted. When
I insert this row....
EXCEL automatically changes the first two equation to
=SUM(G$1:G35)>=G$30 and
=SUM(G$1:G35)>=G30
While the third equation adjusts to what I want, (and see when
the same formula is used in a normal cell).
=SUM(G$36:G36)>=G$30
Can anyone explain why EXCEL is doing this?