Jim,
Select A1:Z1 and copy it, then select cell A1 on the second sheet. Use
paste special (check the transpose box). That flips your data from
horizontal to vertical so it's in rows.
To format the cells, go to Format: Conditional formatting. If the cell
value is "equal to" then specify "0" and click the format button to
select the color of the pattern you want.
Hope it helps,
Phillycheese


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=491051