Probably nowhere near the answer you are seeking, but if you use CFPlus
(http://www.xldynamic.com/source/xld.....Download.html), that has an
option to highlight the ranges formatted with the tool. You can then click
on the highlighted area to see the formula behind it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Nicolle K." wrote in message
...
Example:

Cells A1:A4 have conditional formatting set up that states if they are
equal
to cell A10 they will be highlighted yellow.

Is there a way to quickly see what cells drive conditional formatting? In
other words, we can use Edit - Go To Special to see which cells have
conditional formatting applied; however, this doesn't show us that A10 is
involved. Since there isn't a formula directly involved, we can't trace
precedents/dependents. Can we only know that A10 is involved in the
formatting of A1:A4 by selecting those cells and going into the
conditional
formatting dialog box? Is there another, faster way?