Trace cells by color.
Dependency Auditor filters colored cells and shows them as menu.
You can easily filter all cells, which has a specific background color, or text
color. In filter's window all Dependency Auditor's commands (Trace Dependents,
Trace Precedents, ...) are available in context menu.
This feature will help you in various cases :
-
Your macro colors some cells with a specific background color.
-
You've marked several cells with a color.
-
You want to check, that you spreadsheet doesn't contain cells of a specific
color.
-
and more ...