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 directory
>
any 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

On Thu, 17 Nov 2005 21:54:15 +0100, "Peter STEVENS"
<[email protected]> wrote:

>
>
>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 directory
>>
>any idea's in this usergroup ?
>
>Peter
>