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.
Steve James
shared this idea
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
49 comments
-
cristina john
commented
Our the purpose is to share the reviews about the latest Jackets,Coats and Vests also share the related Movies,Gaming, Casual,Faux Leather and Leather materials available here. https://www.famousmoviejackets.com/john-connor-terminator-salvation-alpha-b3-bomber-jacket/
-
cristina john
commented
Such an interesting article here.I was searching for something like that for quite a long time and at last I have found it here. https://www.famousmoviejackets.com/star-wars-force-awakens-john-boyega-finn-jacket/
-
uu
commented
Hey Admin !
Are you using Excel ?
I wish that you create and edit conditional formatting until the end of your life !!!! -
Lz.
commented
THANK YOU Excel Team
-
Futski
commented
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.
-
Futski
commented
I thought I'd attach a few screen shots. You can see how much more space you have.
-
Futski
commented
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.
-
SR
commented
I just got 16.0.13628.20128 and it is not resizable.
-
NB
commented
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
-
Toni
commented
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.
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10561194-conditional-formatting-apply-to-named-ranges -
Keith
commented
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.
-
Stephan Keller
commented
@Microsoft Moderator:
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. ]
-
Stephan Keller
commented
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. -
Futski
commented
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
Yea!!! -
Anonymous
commented
Awesome! Looking forward to it.
-
Rick
commented
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.
-
Anonymous
commented
