Make Conditional Formatting Rules Editor window sizable.
Make Conditional Formatting Rules Editor window sizable.
Thank you for taking your time to suggest and vote for “make conditional formatting rules editor window sizeable”. While this is an interesting suggestion, we don’t think that we’ll be able to work on this in the near future. When our plans are updated we will re-open voting and you will be notified.
m jackets commented
This is the first time that I visit here. I found so many exciting matters in this particular blog, One thing I would like to request you that pls keep posting such type of informative blog.
brad silva commented
thanks for such an informative knowledge excel is very important on daily work routine glad to find it
Tim B. Homes commented
Thanks a lot to share the knowledge. excel is the most important part of our daily life. mostly work doing on excel use formula easy to work. plans update re-open the voting file etc. [url=https://www.ultimojackets.com/]leather sleeve jacket mens[/url]
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!
Monica Phillipa commented
This site looks amazing very good and informative are mention here with exciting content I read all of them and want to know more also. This is all about IT technology.
Whether you are moving into a new apartment or selling yours to another person, Saints 2 Clean is a cleaning services company NYC working to make your place spotless in no time. We are a professional cleaning program working to provide a hygienic and fresh environment to make an impression on our clients.
Whether you are moving into a new apartment or selling yours to another person, <a href="https://saints2clean.com/">Saints 2 Clean</a> is a cleaning services company NYC working to make your place spotless in no time. We are a professional cleaning program working to provide a hygienic and fresh environment to make an impression on our clients.
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
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.
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/