Highlighted parenthesis in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1773696%22%20slang%3D%22en-US%22%3EHighlighted%20parenthesis%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1773696%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EIs%20there%20a%20way%20when%20you%20go%20to%20a%20parenthesis%20in%20the%20formula%20bar%20of%20Excel%2C%20to%20be%20more%20bolded%20than%20it%20is%20now%3F%20And%20also%20to%20keep%20the%20bold%20more%20time%20than%20now%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20workbooks%20in%20my%20job%20with%20complex%20formulas%20of%205%20or%2010%20lines%20in%20the%20formula%20bar%20with%20a%20lot%20of%20open%20and%20close%20parentheses.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EIn%20order%20to%20understand%20the%20complex%20formula%2C%20I%20copy-paste%20it%20to%20Notepad%20%2B%2B%2C%20where%20if%20you%20click%20near%20a%20parenthesis%20(left%20or%20right)%20it%20makes%20the%20parenthesis%20pair%20red%20and%20also%20keeps%20it.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ECan%20we%20have%20something%20similar%20to%20Excel%3F%20I'm%20using%20Excel%202016.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThank%20you%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ENick%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1773696%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1774225%22%20slang%3D%22en-US%22%3ERe%3A%20Highlighted%20parenthesis%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1774225%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F222052%22%20target%3D%22_blank%22%3E%40Nick%20Panagiotopoulos%3C%2FA%3E%3C%2FP%3E%0A%3CP%3ENick%2C%20it's%20worth%20publish%20this%20idea%20on%20excel.uservoice.com%2C%20that's%20what%20Microsoft%20monitors.%20Perhaps%20similar%20are%20already%20exist%2C%20I%20didn't%20check.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1774475%22%20slang%3D%22en-US%22%3ERe%3A%20Highlighted%20parenthesis%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1774475%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOK%2C%20thank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Is there a way when you go to a parenthesis in the formula bar of Excel, to be more bolded than it is now? And also to keep the bold more time than now?
I have workbooks in my job with complex formulas of 5 or 10 lines in the formula bar with a lot of open and close parentheses.
In order to understand the complex formula, I copy-paste it to Notepad ++, where if you click near a parenthesis (left or right) it makes the parenthesis pair red and also keeps it.

Can we have something similar to Excel? I'm using Excel 2016.

Thank you

Nick

5 Replies

@Nick Panagiotopoulos

Nick, it's worth publish this idea on excel.uservoice.com, that's what Microsoft monitors. Perhaps similar are already exist, I didn't check. 

@Sergei Baklan 

OK, thank you

 

As far my experience,,, no you can't apply color to formula even not on the parenthesis, may be you have never noticed that as soon you select the cell has formula and press F2,,, excel deactivates the FONT section under HOME TAB,,,, !!

@Rajesh-S 

Applying another color, even if possible, practically won't help. However, highlighting as in Notepad++ or other editors will be useful. Such functionality together with formula formatter, if introduced one day, will be quite useful.

Yeah you are write,,, I think since Excel does have Formula auditing facility, helps to check entire formula in parts is also quite useful.

@nick PanagiotopoulosNEW