July 13, 2010

EXCEL - Function to filter Cell color or Font color on excel 2003

Function GetBackgroundColor(MyRange As Range)

GetBackgroundColor = MyRange.Interior.ColorIndex

End Function


 

Function GetFontColor(MyRange As Range)

GetFontColor = MyRange.Font.ColorIndex

End Function
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)