Feedback by UserVoice

Jon Wittwer

My feedback

  1. 787 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)

    Jon Wittwer commented  · 

    This is an excellent suggestion! If the other conditional formatting suggestion for avoiding splitting rules doesn't end up getting done, then using a named range in the Applies To field would provide the way to avoid causing duplicate rule sets when copy/pasting rows and columns.

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

    We’ll send you updates on this idea

    Jon Wittwer commented  · 

    Excellent suggestion. You could also modernize the formatting options by using css-style formatting syntax. For example:

    =FORMAT(B3,"font-size:0.9em;font-weight:bold;text-decoration:underline;font-style:italic")

    Using css-style formatting syntax (or a syntax that was easily translated to css) would make it able to be compatible with Excel online.

    Superscript could be done with css (via vertical-align:top and font-size:0.75em).

    For that matter, why stop at just font formatting? You could create a function like =FORMATCELL("css-syntax") that would format the background color and cell borders as well (making sure to allow cell border width, not just color). If you wanted the cell to contain a formula, then allow FORMATCELL to have the syntax =FORMATCELL(formula,"css-syntax"). That would be awesome!

    Oh, and while we're at it, how about a new TEXT function that allows you to specify custom number formats such as "[red]0.00;[color10]-0.00;0;@"

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

    We’ll send you updates on this idea

    Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

    Thanks,
    John [MS XL]

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Jon Wittwer supported this idea  · 
  6. 36 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Wittwer shared this idea  · 
  7. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Wittwer commented  · 

    I would like the function to handle daylight saving time (DST), meaning something like CONVERT(datetime,"Mountain","Eastern"), but that would not be trivial because of the change in the laws regarding DST over time. The function would need to be more than just a table of UTC offsets. Having a function that was able to handle DST in date/time conversions would be much more powerful than just applying a simple UTC offset, because handling DST is difficult to do in a spreadsheet with just formulas.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Jon Wittwer shared this idea  · 
  10. 22 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Wittwer commented  · 
    Jon Wittwer supported this idea  · 
  11. 94 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Wittwer shared this idea  · 
  12. 1,074 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

    Jon Wittwer supported this idea  · 
  13. 138 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Wittwer commented  · 

    If the only type of conditional formatting is a gradient based on the series value, then color will just be a redundant dimension (because the relative sizes of bars or positions of data points already show the value).

    However, if you can create a rule set that uses a formula where references are relative to the series value range, then you can do some powerful things, limited only by what you can do with a formula.

    Consider the following series for a column chart:
    SERIES("Name",Sheet1!$A$1:$A$10,Sheet1!$B$1:$B$10,1)

    The following might be a rule to color the bars of the chart a certain color if the category name contains the letter "g"
    Rule: =NOT(ISERROR(FIND("g",A1,1)))

    The following rule might be used to color the bars red if the value in column C is "high" (for example, if column C represented a priority level)
    Rule: =(C1="high")

    An idea for the GUI: In the Conditional Formatting Rules Manager, the "Show formatting fules for:" field could include a list of the valid chart series in the worksheet such as "Chart 2:Series1" ... which would allow you to easily add and edit multiple rules for that series.

    Jon Wittwer supported this idea  · 
  14. 197 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

    Best,
    John [MS XL]

    Jon Wittwer supported this idea  · 
  15. 911 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!

    John, Excel

    Jon Wittwer supported this idea  · 
  16. 1,035 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Jon Wittwer shared this idea  · 
  18. 56 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Wittwer shared this idea  · 
  19. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Wittwer shared this idea  · 

Feedback and Knowledge Base