colour due to conditional formatting & hyperlink/shortcut to a directory

[Peter STEVENS]

Hello ,
I'm trying to solve 2 of my excel problems :1. a function or macro that allows to determine which font and/or
background colour were assigned due to the conditional formatting of a
cell.
2. a way to include a hyperlink or a shortcut to a directory that runs
explorer to open that directoryany idea's in this usergroup ?

Peter

 

[Gord Dibben]

Peter

See Chip Pearson's site for answer to number 1

For number 2.......

Create a shortcut on your desktop to the folder in question.

In an Excel cell right-click and create hyperlink to that shortcut.


Gord Dibben Excel MVP