Forum Discussion
Cannot use 'cmd' to take away cells in selected range when adjusting range for conditional formattin
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.
6 Replies
- Not much consolation but what you describe works fine on a PC. There is new functionality to duplicate a rule and I would have thought that the ability to reapply it to a new range must be supported?
PeterBartholomew1 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?
- No, I didn't try that. I simply selected a new range. I can see that if you are applying the condition to a complex multi-area range, that would not be fun.
