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
|