195 votes22 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
Great suggestion, thanks David! And thanks to other people who took the time to clarify/comment on this one. There’s definitely room to tighten this experience up in a number of places. We’re getting a lot of traffic on the site, so please keep voting for the things you care about most to help us do a great job of prioritizing.
John [MS XL]Emre Poyraz commented
Hello, I agree with you all. Conditional formatting with formulas is quite a mess.
I think the main problem is this: there is a conflict between APPLIES TO and SELECTION. Excel is trying to choose one row less then our selection and apply the formula accordingly, but messes up.
Compounding this problem: When you have a table in Excel, the first CTRL+A selects the table WITHOUT the header. The second CTRL+A selects the table WITH the header. This makes it more difficult for Excel to decide where to apply the formula to.
I have to manually change this everytime I use conditional formatting with formulas (Manage Rules). Check the first row in Applies to and change to formula accordingly (interestingly, it works well after the first change).
I believe this can and should be fixed.
PS: If you dont want the arrow to point to new cells using arrow keys, press F2.
6,287 votes436 comments · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Admin →
Thank you to all those participated in our survey. What an amazing number of responses, many of them with very deep content. We’re processing the over ten thousand responses(!), and already appreciate the time so many of you took to answer with passion and experience.
Please know this survey is used to help influence various topics – both on Python as well as other related topics that the comments started to bleed into. Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.
We’ll provide updates as we progress on this feature request.
Lead Program Manager
ExcelEmre Poyraz commented
I dont think Python should replace Excel functions. Excel functions are very mature and popular.
But how about having a Python based macro ability for excel? This could be an add-on. Python modules for Excel are not good enough to replace VBA.