A row would be handled like this:
With Rows(x).Interior.ColorIndex = 6
The number 6 = Yellow
Colorindex Property in VBA Help will help you with the othe
colors/numbers
-Piku
-----------------------------------------------
~~ Message posted from
http://www.ExcelTip.com
~~View and post usenet messages directly from
http://www.ExcelForum.com
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements