The Conditional Formatting Rules Manager badly needs the ability to be resized
The Conditional Formatting Rules Manager dialog box is far too small for modern display resolutions. It really should be a resizeable dialog, and should include the ability to resize column widths, so that the full length of complex conditional formatting expressions can be displayed and read without having to open them for editing.
We’re happy to announce this improvement to the Conditional Formatting dialogs in Excel for Windows. If you’re a Microsoft 365 subscriber, they’re now resizable so you can see more rules at a time, and it’s easier to see the formula and range that the rules apply to. This includes the Conditional Formatting Rules Manager and New/Edit Rule dialogs.
Please see this for more information – https://techcommunity.microsoft.com/t5/excel-blog/resizable-conditional-formatting-dialogs/ba-p/2180229
THANK YOU Excel Team
One thing I forgot to mention, As you can see in the screen shot of the Rules Manager, you will be able to duplicate a rule with one click. They added a Duplicate Rule button next to Delete Rule.
I thought I'd attach a few screen shots. You can see how much more space you have.
I'm on Insider Beta version 16.0.138 and it does have a resizable Rules manager. The "Rule" and "Applies To" columns widths both resize dynamically depending on the dialog box width. In addition the dialog box can also change height-wise to display more rules. The dialog box can be streteched to full screen giving lot of room, but there is no "Maximize" button in the upper right corner.
The "New/Edit Rule" dialog box, however, is only resizable horizontally. It does not do vertical resizing which is unfortunate. They could use the increased vertical space to increase the vert. size of the "Select New Rule Type" box or increase the height of "Rule Formula" input box.
If you want to see these in action and don't have it yet, you can swicth to Insider Beta and get the changes ASAP.
I just got 16.0.13628.20128 and it is not resizable.
my version is 16.0.5095 and the CF window is still not resizable
Kevin Osborn commented
A good start but the area to enter a formula is not expandable. Why not make that window not only able to resize the width but also the height so that the formula bar can wrap
So this is merely graphic and is planned, what about the functionality? You have already made the Webb formating very limited and are yet to repair a long long problem with the desktop one... But aesthetics first... OK.here is the link to the other one, quite entertaining.
Excel.uservoice.com moderators should realize that their company can get into big trouble by hosting advertising selling oxycodone.
Even if you leave up the ads selling pirated movies, you need to take down the narcotics advertising.
The number of entered inappropriate comments is growing and growing.
Could a moderator of this forum please block the related user accounts and remove these comments?
Thanks a lot.
[ Does a click on "Flag as inappropriate" effect anything? When I reload the page the status "Flagged" has gone away and "Flag as inappropriate" is displayed again. ]
Currently there are 10 inappropriate comments displayed (just on the first page displayed), I flagged them.
Could a moderator of this forum please remove them?
Thanks a lot.
Great News everyone. I see that as of Oct 30, 2020, this has been released to Office Insider Beta channel.
See here https://insider.office.com/en-us/releasenotes/windows/fast/windows-beta-channel-release-notes
Awesome! Looking forward to it.
Thanks for the news, Steve!
Peter Davies commented
This needs to be classed as 'urgent' - trying to edit a conditional rule is like trying to scramble eggs through a letterbox.
Kevin Osborn commented
Awesome news. Please be sure to remember the size/position the window Cond Rules window is in the last time it was closed instead of forcing the user to resize it every time it is opened.
I cannot understand the ADMIN's answer: "While this is an interesting suggestion, we don’t think that we’ll be able to work on this in the near future".
Could it be, that there is a massiv lack of know how in the MS staff, not being able anymore to maintain the core code of Excel?
This would also explain, why the Office-UI is changed over and over again, but nobody asked for all these GU gimics. But bugs stay unfixed.
After all, a really sad story: Years ago MS pushed out all other Excel alternatives with its marketing power, and now, they don't listens to the user feedback.
Also look at the Feedback from 2015: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/8778211-improve-the-conditional-formatting-manager
Nik Warburton commented
@Bing Xie that's really helpful, thanks! I was hoping it would also work on the Conditional Formatting Rules Manager window, but it doesn't extend the inner window, which is a shame, but your solution is definitely very helpful :)
It just goes to show that all Microsoft need to do is add this one property to the window when it's generated - it's utterly shocking that they won't do this. With any decent open source software, someone like yourself could have submitted this fix and it would have been live by now!
Bing Xie commented
Just tried to make the "Edit Formatting Rule" dialog resizable and it seems to work better than the "Conditional Formatting Rules Manager" window. See attached.
Since Microsoft won't make this change, you can enable this using an AutoHotKey script like the following:
#IfWinActive New Formatting Rule
#IfWinActive Edit Formatting Rule
WinSet, Style, +0x40000, A ; WS_THICKFRAME
With the script, you can press F6 to make the window resizable whenever you are in the "New Formatting Rule" or "Edit Formatting Rule" dialog.