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
Stephan Keller commented
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.
@Nik W - You are 100% correct. As a fellow coder, I can attest that changing the window to resizable is mere child's play. Very sad indeed especially given the frustration of having to deal with fixed width windows. Real PITA when dealing with long rules etc.
Bryon Smedley commented
This is sad; just sad. It probably took more time to decide NOT to do this than to fix the issue. Another win for bureaucracy.
Nik W commented
Absolutely disgraceful decision. I am a programmer and I can tell you that it is INCREDIBLY easy to change a window to resizeable. It's literally just altering the property of that window to make it resizable. It would take longer to find the code section relevant to creating the window than it would to alter it to be resizable. You do not have to rewrite anything regarding the content or the layout - all this is done automagically when the window is resized. If you asked one of your developers to do this, they'd have it done within 10 seconds of finding the relevant line of code to alter.
Geoffroy Menard commented
This is unacceptable, do you know how obnoxious this is when using dozens of rules?!?
Seriously MS? You can't make the conditional formatting pop up box sizable? But it is no problem to have your other pop up boxes sizable? This really doesn't make sense. MS is just such a disappointment. With the advent of comparable, if not superior, products it is a wonder that businesses choose MS at all.
Tim Ellis commented
Bit disappointing, I would have thought this would have been a relatively simple change to put in place. I would appreciate if you could reconsider, thanks.
"Not at this Time" says admin. How disappointing. This could have been a very simple change. It's not like a re-sizable form is a big deal.
MS should be assigned to a rookie coder. What a great way for them to get their feet wet after joining the Excel Dev team. Just change the pop-up form type from Fixed to Re-sizable and add a little code to adjust the text boxes inside the form. I've done this myself in many VB apps. Child's play.
Elizabeth Mathew commented
Conditional formatting in excel is a bit tough but i have learned it step by step and it really helped me highlight, emphasize, and differentiate by using colors and make the reports for my website: https://www.leatherjacket4.com/leather-jacket/shearling-leather-jacket
Allow resizing of the Conditional Formatting window, showing 5 rules only makes it very time consuming to work through all the rules.
A.C. WILSON commented
Like Sandy Vasquez, I too sometimes have to edit Excel and Access formulas by using Word, in which it's much easier to do (temporary) indenting for visually ensuring that the parentheses are all in itheir correct places.
Sandy Vasquez commented
Making the Conditional Formating editor window sizable would be a godsend. Maintaing the integrity of formulas in the small limited space is formidable. To edit longer fx, I copy them into word, edit and then repaste. What a loss of time there! Thanks for listening.
Jan Wx, NZ commented
Absolutely - this is so overdue. Plus I seem to think that in the past we could at least resize the columns but that no longer works
George William commented
Conditional formatting is used frequently, making it resizeable will help a lot to copy you formulas easily, as I was facing this problem while making a report for https://videocottage.co.uk/
Wayne Dietz commented
I am very shocked after reading your title but I’m reading your whole post so I know your post title. I am very impressed with your writing and I also follow up in https://www.animationdok.com/
Core Puncher commented
Come on guys, make this happen! I have so many rules and a tiny little "viewfinder". It's as if they started it, then forgot to finish.
Kevin Osborn commented
This suggestion is accepting votes so I encourage everyone to go vote here and also add you comments to give more support to improving CF.
Kevin Osborn commented
Conditional formatting is arguably the most "left behind" area in Excel.
- Make conditional formatting rules editor window sizable >> Yes
- Make live preview >> Yes
- Make formulas work like real formulas (auto complete, error checking, allow named ranges and structured reference, make them follow normal volatility rules based on the formulas used) >> Yes
- Additions/Subtractions/Moving ranges should not fragment the CF ranges >> Yes