Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
colour due to conditional formatting & hyperlink/shortcut to a directory
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
colour due to conditional formatting & hyperlink/shortcut to a directory
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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |