Cells Used In Cond. Formats Don't Show Trace Dependencies

[throtmorton]

Hi,

I just noticed today that it doesn't appear that Excel shows trace dependencies for a cell for uses in conditional formatting. Is this the case? Any known workarounds? I have a habit of trimming out orphaned cells, but I could easily mess things up for the conditional formatting.

Thanks,
Paul

 

[RalphA]

What are "trace dependencies", and what are "orphaned cells"?

 

[throtmorton]

Sorry, by trace dependencies I mean cells that refer to this cell, as opposed to precedents. "Orphans" is my term for cells that I come across some time after I've made them, and can no longer find uses for.

 

[RalphA]

I just noticed today that it doesn't appear that Excel shows trace dependencies for a cell for uses in conditional formatting.

Could you post one or two examples?