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 w...
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.
- Well my issue with the most recent case is that i want it to apply to the whole of several columns except for just the top row. So when I first made the range I just highlighted all the relevant columns at the top, held down cmd and selected the top row of those columns... job done. But when I already have a rule and want to edit the range (mainly cos excel has glitched out and changed the range) when i hold cmd this time it just adds another instance of the top row rather than takes it away. And other than clicking and dragging from the 2nd row right to the bottom of the worksheet which would probably take hours if not days, I cannot think of another way to select this simple range.
- The idea of removing cells from a selected range is something I was vaguely aware of, but never had cause to use. On the pc, it seems to work (using Ctrl) directly from the grid but not from conditional formatting. Something that does work is to select cells from the 2nd row and use Ctrl/Shift/Down to extend the range.