little off topic, but with excel 2010 conditional formatting properties will be accessible through vb
have a look he
new class: Selection.DisplayFormat.Interior.Color
<http://blogs.msdn.com/excel/archive/2009/08/13/the-dislpayformat-om.aspx
--
Gary Keramidas
Excel 2003
|