Feedback by UserVoice

Richard Wein

My feedback

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

    We’ll send you updates on this idea

    Thanks for supporting this feature. We won’t be able to in the near future, but we understand that it would be a nice improvement. Even though it seems like a straightforward idea, it is quite complex since named ranges can be dynamic, meaning that the range is calculated when the workbook is calculated.

    We’ll continue tracking votes for this suggestion.

    An error occurred while saving the comment
    Richard Wein commented  · 

    Absolutely essential. For me conditional formatting is currently broken. I just googled this problem in the hope of finding a solution. Since it seems there isn't one, I'm now thinking I should remove the conditional formatting from the project I'm working on. What a nuisance.

    Richard Wein supported this idea  · 
  2. 120 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Richard Wein supported this idea  · 
    An error occurred while saving the comment
    Richard Wein commented  · 

    ms@baccma's suggestion is good too.

    An error occurred while saving the comment
    Richard Wein commented  · 

    Great idea, Carole. I was struggling with this just yesterday, trying to to find a way to make my exception condition return an error, so I could use IFERROR. I failed, so had to duplicate my long expression.

    Alternative name suggestion: IFSHORT. It's really a general-purpose function, like IF, except that it restricts the condition to one that tests the value of one of the two alternative output expressions. It could allow tests for non-equality, e.g. ">0" (in quotes) for the first argument.

Feedback and Knowledge Base