Feedback by UserVoice

 

How can we improve Excel for Windows (Desktop Application)?

← Excel for Windows (Desktop Application)

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.

189 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Steve James shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded  · 

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

Show previous admin responses (2)

46 comments

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Futski commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • NB commented  ·   ·  Flag as inappropriate

    my version is 16.0.5095 and the CF window is still not resizable

  • Kevin Osborn commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    @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  ·   ·  Flag as inappropriate

    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.

  • Peter Davies commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • Stephan Keller commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    @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  ·   ·  Flag as inappropriate

    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
    F6::
    #IfWinActive Edit Formatting Rule
    F6::
    WinSet, Style, +0x40000, A ; WS_THICKFRAME
    return

    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.

← Previous 1 3

Excel for Windows (Desktop Application): Formatting

Categories

Feedback and Knowledge Base

(thinking…)