Trace cells by color
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 ...
NoteUse Refresh command to update filtered data.