Closed Thread
Results 1 to 16 of 16

Color Coding Parenthesis and Groupings in Formula Editor

  1. #1
    Spammer
    Join Date
    02-21-2018
    Location
    England
    MS-Off Ver
    Excel 2016(&2010,2007), Word 2016 (&2010,2010)
    Posts
    141

    Color Coding Parenthesis and Groupings in Formula Editor

    how to Color Code Parenthesis to Group them according to levels in Formula Editor to make it easier to understand

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Color Coding Parenthesis and Groupings in Formula Editor

    I don't know formula editor but the moment you add aa formula in Excel the corresponding parenthesis color according to the series it belongs to
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,413

    Re: Color Coding Parenthesis and Groupings in Formula Editor

    By formula editor, do you mean the formula bar below the ribbon?

    If so, then it should show colour coding as you build up your formula.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Spammer
    Join Date
    02-21-2018
    Location
    England
    MS-Off Ver
    Excel 2016(&2010,2007), Word 2016 (&2010,2010)
    Posts
    141

    Re: Color Coding Parenthesis and Groupings in Formula Editor

    Brackets aren't color coded in sheet that I downloaded from this forum's post.
    But,It works when I type the formula

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,413

    Re: Color Coding Parenthesis and Groupings in Formula Editor

    They should be when you place the cursor into the formula bar, but will not be visible otherwise. Perhaps you can provide a workbook where it is not working as you expect?

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Color Coding Parenthesis and Groupings in Formula Editor

    If you simply select a cell having a formula it will not show any color coding
    formulanocolor.JPG

    If you edit the cell (double click, or F2) then the color coding will be shown in the cell. If you click in the Formula Bar, then the color coding will also be shown in the Formula Bar:

    The colors are more vivid in Excel than they look in my screenshot.

    formulacolor.JPG
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Color Coding Parenthesis and Groupings in Formula Editor

    Quote Originally Posted by Excelforum*ser_mH7 View Post
    Brackets aren't color coded in sheet that I downloaded from this forum's post.
    But,It works when I type the formula
    That could be because the formula has been entered in text mode? If you look at the cell, does it show the answer or the formula?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  8. #8
    Spammer
    Join Date
    02-21-2018
    Location
    England
    MS-Off Ver
    Excel 2016(&2010,2007), Word 2016 (&2010,2010)
    Posts
    141

    Re: Color Coding Parenthesis and Groupings in Formula Editor


  9. #9
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Color Coding Parenthesis and Groupings in Formula Editor

    brackets are coloured

    brackets.jpg

  10. #10
    Spammer
    Join Date
    02-21-2018
    Location
    England
    MS-Off Ver
    Excel 2016(&2010,2007), Word 2016 (&2010,2010)
    Posts
    141

    Re: Color Coding Parenthesis and Groupings in Formula Editor

    How to make these color more contrast/bright/different/differential.

  11. #11
    Spammer
    Join Date
    02-21-2018
    Location
    England
    MS-Off Ver
    Excel 2016(&2010,2007), Word 2016 (&2010,2010)
    Posts
    141

    Re: Color Coding Parenthesis and Groupings in Formula Editor

    They colored when F2 in cell but not in formula bar.

  12. #12
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Color Coding Parenthesis and Groupings in Formula Editor

    run the windows Loupe and see formula bar

    fb.jpg

    edit:
    and afaik, you can't change default colours of brackets in formula
    Last edited by sandy666; 06-18-2018 at 03:37 AM.

  13. #13
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Color Coding Parenthesis and Groupings in Formula Editor

    I dont believe you can change the appearance of those.

  14. #14
    Registered User
    Join Date
    01-31-2005
    Posts
    17

    Re: Color Coding Parenthesis and Groupings in Formula Editor

    I know this is an old thread but working with 2019 version of office the colors are so muted you can't see the damn pairs!

    This is an enlarged and bolded formula I'm testing (with numbers in place of variables.)
    Even as shown you can barely tell the difference between the two (()) after the TRUNC function. Purple vs Maroon?

    And between (8*(24*24) teal vs Blue?

    I don't want to STUDY the graphics of the formula, I want to focus on the formula!?!?!?!?!


    Where the F@#$#$% are the designers of this? I'd be EMBARRASSED to have a client try to use this.


    Excel colors.jpg

  15. #15
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,413

    Re: Color Coding Parenthesis and Groupings in Formula Editor

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

  16. #16
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Color Coding Parenthesis and Groupings in Formula Editor

    Just to respond to your rant...
    if you know how to read formulas, then that formula is pretty easy to read...and the colors just make it even easier (and I have had cataract surgery and have not yet been tested for reading glasses)

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. DatedIf formula with conditional formating and color coding
    By Scrapnforfun in forum Excel General
    Replies: 1
    Last Post: 05-20-2017, 12:50 AM
  2. Formula for color-coding cells
    By DarrellH in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-02-2017, 11:38 AM
  3. Replies: 1
    Last Post: 04-10-2016, 11:42 AM
  4. trying to create a formula for rules and color coding
    By philter451 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2014, 09:30 PM
  5. Need to add Color coding to Countif formula
    By Snickers in forum Excel General
    Replies: 0
    Last Post: 01-04-2011, 01:58 PM
  6. Formula for color coding
    By rlkerr1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-08-2008, 04:48 PM
  7. Formula Color Coding
    By Andrew in forum Excel General
    Replies: 5
    Last Post: 03-25-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1