Hi, hope this gets you started:

1) & 2) There are 65,536 rows and 256 columns in an excel worksheet.

3) Look at these links for some help with selecting and coloring the
rows:
http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/cformatting.htm

Regards--Lonnie M.