Feedback by UserVoice

Anonymous

My feedback

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

    We’ll send you updates on this idea

    Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.

    Thanks,
    Steve (MS Excel)

    Anonymous commented  · 

    @roy

    A1:F4 is range...

    =A1:F4 is a formula

    you don't give name, like "sales" to a range such as B1:B4... you set the formula =B1:B4 to the name "sales"

    In fact you could also set an entire matrix formula to a name, and therefore the name sales could get the formula =SUM(IF(A1:A4="North",B1:B4,"")).... could it be possible that such formula assigne to "sales" have a conditiional format? would you say this "sales" is a named RANGE?

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

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

    We’ll send you updates on this idea

    Anonymous commented  · 

    if you want more people to use PowerQuery, you have to help and typing functions easier. Intellisense is needed

    Anonymous supported this idea  · 

Feedback and Knowledge Base