Oct 24 2019 12:29 PM
I am breaking down and rebuilding a worksheet made many years ago.
There are two cells in the worksheet that both have a TRUE/FALSE indicator, however they are just text and not a formula.
I've traced precedents (none), descendants (some), turned on formulas, made sure all text is readable etc and for the life of me I just can't find it!
One appears to be connected to a developer drop-down box, but there's no VBA or anything that's helping me in my detective work.
Where else could I look?
Note - unfortunately due to the nature of the content on the workbook I am unable to upload it here.
Oct 24 2019 05:41 PM
Oct 24 2019 09:43 PM
You mentioned there were some dependents? so isn't that what you are looking for?
Also as well as the dependent forrmula there could be conditional formatting rules linked to those cells which don't show up when tracing dependents