Apr 18 2021 02:23 PM
Hi, I was instructed to post this here as the original Microsoft agent was unable to solve my query.
So I started to notice a few inaccuracies in my conditional formatting on my spreadsheet and when i checked the mange rules section i noticed that they had all been completely changed. The range for the 4 I had created had changed and become very weird and complicated with strange overlaps, and also about 20 other rules had been created which I did not make.
I have deleted the new ones and just need to adjust the range for the original rules, but for some reason I cannot select the area I want as I need the 'cmd' function to take away certain cells, which works when initially selecting a range but for some reason, not when selecting for a rule already created, and I don't really want to have to recreate the rules again from scratch.
Apr 18 2021 03:01 PM
Apr 18 2021 03:14 PM
@Peter Bartholomew no i tried that but duplicating includes the cell range so i would still need to edit the range of the new duplicated rule. So on a pc, when you are editing a range, (not selecting a range initially), you can select an area, then hold down (i'm guessing ctrl on a windows?), and then select an area to take away from the already selected area?
Apr 18 2021 03:25 PM
Apr 18 2021 03:36 PM
Apr 18 2021 11:33 PM
Apr 19 2021 12:01 AM
@Peter Bartholomew Ooh yes that does work! Like you said though, wouldn't be great if one had a more complex range. Seems odd that a tool they've provided, they've decided to make unavailable in other similar situations though. And then there's still just the issue of why the ranges get corrupted in the first place. I have noticed that the problem occurs when I try to insert new rows, (which I will constantly be having to do). The row below the new row gets separated into its own rule. And further complications happen if I copy and paste from the row below the new row.