Feedback by UserVoice

Kevin Osborn

My feedback

  1. 180 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    I have great news to share. We are planning to make the Conditional Formatting Rules Manager and rules dialogs resizable. Thanks for all the votes and comments for this suggestion.

    We’ll provide more updates here as we get closer to releasing the update.

    Steve [Microsoft Excel]

    An error occurred while saving the comment
    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.

    An error occurred while saving the comment
    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.

    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/8778211-improve-the-conditional-formatting-manager?page=3&per_page=20

    An error occurred while saving the comment
    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

    Kevin Osborn supported this idea  · 
  2. 1,925 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  3. 26 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  4. 104 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  5. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  6. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kevin Osborn commented  · 

    Agree and voted it up. That said, the workaround is to create a named range in cell A1 (or whatever cell you want) within each sheet and then hyperlink to the named range instead of the sheet.

    Kevin Osborn supported this idea  · 
  7. 11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  8. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  9. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kevin Osborn commented  · 

    Try custom format ;;; which will display nothing regardless of the text or cell color.

  10. 21 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  11. 269 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kevin Osborn commented  · 

    Microsoft ... time to take this one to a vote. It's buried being 5 years old but it's a serious issue. No reason in 2020 that the user cannot start typing and have the data validation list open and go to the first combination of the characters entered.

    ps. And allow Tab to select the item and move to the the next cell. Don't force the user to only select the item using the Enter key.

    Kevin Osborn supported this idea  · 
  12. 11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kevin Osborn commented  · 

    @Harlan Grove ... you have a good point with respect to your example where one formula refers to 2 cells and you cut one cell and paste into the other.

    I run into this problem all the time as it relates to tables. It's not related to cut/paste but frequently a column or whole table is deleted. Frequently it's related to Power Query where the PQ changes and thus the output table changes. Here is what happens and why this is so frustrating.

    A1 = XLOOKUP("ABC",Table1[Column1],Table1[Column2]). Column 2 disappears for some reason (see above) and Excel now shows A1 = XLOOKUP("ABC",Table1[Column1],#REF!). So it is impossible to look at A1 and know what was intended in the formula. If the formula was left as it was originally and the result was #REF then it would be easy to find the problem and fix it.

    I would be ok if Excel provided a warning IFF (if and ONLY if) the warning was not generic and actually told the user what cells and formulas were going to be affected and the message could be copied to the clipboard or provided in a new sheet (e.g. Check Compatibility > Copy to New Sheet). There are too many cases (e.g. Links, Pivot Tables) where Excel provides a message (e.g. broken links) but does not provide a way to find what was broken.

    Kevin Osborn supported this idea  · 
  13. 11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  14. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  15. 1,018 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  16. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  17. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  18. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kevin Osborn commented  · 

    To do this you can use the UNIQUE function.

    A1 = UNIQUE(B1:B10). Then in your data validation select list and assign it to =A1#.

    That said this requires a spilled array created just for this purpose so I like you concept of a checkbox added when "select from list" is selected for Unique. It would also be nice to have a similar checkbox to "ignore blank in list" to not show a blank value if blank exists in the list.

    Kevin Osborn supported this idea  · 
  19. 11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  20. 575 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the suggestion Jessica. We’ve got a few other suggestions on the site that are similar with scientific notation, etc. We’ll take a look at this area, and pay special attention to any cases that get a lot of votes. So please keep the votes coming to help us do a good job at prioritizing asks like this!

    Cheers,
    John [MS XL]

    Kevin Osborn supported this idea  · 
← Previous 1 3 4 5

Feedback and Knowledge Base