Determine cells that drive conditional formatting?

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?

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." <[email protected]> wrote in message
news:[email protected]...
> 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?

Not quite what you ask, but it's pretty quick...

You can customize your toolbar to have an icon that shows the format|conditional
formatting dialog.

Tools|customize|commands tab|Format category (about half way down in xl2002).

Drag that "conditional formatting..." icon/text to your favorite toolbar.

Select a cell, click that button and escape to dismiss it.

(Not really too bad.)

Nicolle K. wrote:
>
> 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?

--

Dave Peterson