Search

Multiple parenthesis colors in Excel formulas

Sometimes we need to stack multiple parentheses in Excel formulas. Stacking multiple parentheses is very useful while writing complex formulas. But many parentheses are often confusing.

Stacking multiple parentheses in Excel formulas can often be confusing. To make stacking multiple parentheses simple, Excel uses colors for stacked parentheses.

The stacked parentheses in Excel are coloured in following order. Black, Red, Purple, Green, Violet, Topaz, Aquamarine and Blue. Once these colours are over, colours are again repeated from Red.

Following image shows different colors used for stacked parentheses in Excel formulas.

multiple-parentheses-colors-in-excel-formulas.jpg

Related Tutorials
Cell reference (Cell address)
Range reference
What are Excel formulas
How to write formulas in Excel
How to see all formulas in Excel sheet
Mathematical operators in Excel
Comparison operators in Excel
Concatenate (&) text operator in Excel
Cell or range reference operators in Excel
Union and Intersection of Excel ranges
Operator Precedence in Excel
How to change the operator precedence in Excel
Error messages in Excel Formulas
Hash error in Excel (#### in excel)
Multiple parenthesis in Excel formulas
Trace error in Excel formulas
How to remove trace error arrows in Excel
Relative and absolute reference in Excel
F4 key in Excel formula
Mixed Cell reference in Excel