Is there a way to tell if a cell is used in a formula somewhere?

%3CLINGO-SUB%20id%3D%22lingo-sub-1875270%22%20slang%3D%22en-US%22%3EIs%20there%20a%20way%20to%20tell%20if%20a%20cell%20is%20used%20in%20a%20formula%20somewhere%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1875270%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20you%20go%20into%20edit%20mode%20on%20a%20cell%20that%20has%20a%20formula%2C%20it%20colorizes%20all%20the%20cells%20it%20uses%20for%20that%20formula.%3CBR%20%2F%3EIs%20there%20a%20way%20to%20do%20the%20other%20way%20around%3F%26nbsp%3B%20i.e.%20focus%20a%20cell%20that%20is%20used%20in%20a%20formula%20and%20have%20it%20highlight%20all%20the%20formulas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1875270%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1875512%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20way%20to%20tell%20if%20a%20cell%20is%20used%20in%20a%20formula%20somewhere%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1875512%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F828549%22%20target%3D%22_blank%22%3E%40Ericson_Mar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20use%20Trace%20Dependents%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20623px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F232888i239575D7A04C80DD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

When you go into edit mode on a cell that has a formula, it colorizes all the cells it uses for that formula.
Is there a way to do the other way around?  i.e. focus a cell that is used in a formula and have it highlight all the formulas?

1 Reply
Highlighted

@Ericson_Mar 

You may use Trace Dependents

image.png