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

throtmorton

Board Regular
Joined
Aug 9, 2005
Messages
94
Office Version
  1. 365
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
What are "trace dependencies", and what are "orphaned cells"?
 

throtmorton

Board Regular
Joined
Aug 9, 2005
Messages
94
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
May 14, 2003
Messages
3,829
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,113,950
Messages
5,545,139
Members
410,665
Latest member
origamistudios
Top