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
blackground 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

 

[Linker IT Software]

2. a way to include a hyperlink or a shortcut to a directory that runs

explorer to open that directory

Type this Excel native formula in a cell:
=HYPERLINK("c:\","Show c:\ in explorer")

It will show the text Show c:\ in explorer and when you click on it it will
open explorer to display the contents of c:\

Gerrit-Jan Linker
Linker IT Software
Developer of litLIB: over 100 extra functions for Excel
www.oraxcel.com/projects/litlib

 

[GregDAngelo]

here's a imple function that you can modify

Public Function font()
MsgBox Range("A1").font.Name & vbCrLf &
Range("A1").Interior.ColorIndex
End Function

you can make this into a proper function that can have a range passed
to it and then do something other than a message box.