User Profile
tjryan35
Copper Contributor
Joined Jan 19, 2022
User Widgets
Recent Discussions
Re: Conditional Format Reference Ranges Shift Wildly
Thanks a lot for your reply. So it sounds like I was kind of on the right track.. the issue is that I often don't have a cell in the to-be effective range selected when I create the rule, so when I change the effective range, it changes the reference I put in the rule formula.Conditional Format Reference Ranges Shift Wildly
Very often when I create a new conditional format by formula, I will hit "ok" and close the window, expecting the rule to be applied, but it does not take effect in the ranges I specified. I now know to immediately go back to the rule I wrote, where I will observe that the relative reference ranges I put in the formula are now shifted by many rows and columns. I can't find any literature online to explain why this happens. It's not a huge inconvenience, but I just wonder why it happens so consistently. Has anyone out there encountered the same thing? Do you know why it happens / how to prevent it? UPDATE: I played around with it a bit, and it seems that it only shifts the references when I update the effective range. As in, at first I just had a random cell selected when I wrote the rule, then I pasted the effective range into that rule from another rule along the same lines. Only then does the reference range shoot out into oblivion and need to be fixed. Still not sure why... Thanks!Excel Freeze Panes error permanently freezes part of sheet even when unfrozen.
I've seen this issue before and never knew how to fix it. Normally I would just copy whatever I need into a new sheet and scrap it, but this table is linked to a PowerApps form I'm working on, and I'm worried it'll screw everything up if I relocate the table. The duplicate row 1 in the picture below is always there no matter where I am in the sheet even though there is no active freeze being applied to the sheet. This error has happened when changing the freeze settings, but I'm not sure what other factors cause it. Does anyone have a fix for this? I couldn't find any other posts about this issue. Thanks a lot!
