On 2002-10-03 16:11, NateO wrote:
Howdy Dave Hawley provides a link to and overview here:
http://www.mrexcel.com/board/viewtopic.php?topic=14605&forum=2
The loop may be a little overkill if you don't care about the order. Follow Dave's instructions on how to use a user defined function at his "Sort" link.
Here's a simplified function and examples:<pre>
Function Clr(myRng As Range)
Clr = myRng.Interior.ColorIndex
End Function</pre>
Hope you're talking about standard formatting and that this helps.
_________________
Cheers,<font size=+2><font color="red">
Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2002-10-03 16:13