Precedents and Dependents in Spreadsheets

In LibreOffice Calc, we can choose the color for the precedent / dependent arrows. In LibreOffice (v5.3), choose    Tools/Options/LibreOffice/Application Colors You can select the color for "Detective" colors. "Detective" is the equivalent to Excel's precedent and dependent tracing. Color for Detective Arrows (Precedents and Dependents) Note that  LibreOffice changes all Detective arrows, including those that are already drawn, to the new color.  It is not possible to get two colors for the arrows in the same screen. However, with Basic programming in LibreOffice, it is possible to trace with different colors in the same sheet (worksheet). This is shown in the following diagram, with the software extension described in this book: Easily understand your spreadsheet model and detect errors with influence charts (For LibreOffice Calc) LibreOffice. Different Precedent Arrow Colors

"Is it possible to format the trace precedents and dependents arrows? I want to change colours of the arrows." In Excel, the answer is no. For LibreOffice Calc, the answer is yes. (See a later post on this) But, in Excel, you can do some programming in VBA to do your own precedent and dependent tracing with the colors of your choice. For example, this diagram with different arrow colors was made with VBA macros. Each color indicates a group of cells that are connected.  The diagram shows 3 colors, indicating 3 groups of cells that are not connected to one another. Precedent Arrows with Different Colors This is done with the VisualCheck software described in this book: Influence charts: How to easily gain a powerful overview of your Excel spreadsheet model