View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JIM.H.
 
Posts: n/a
Default Q: columns to rows

Hello,

Sheet1 has column based data such as there are values in A1,B1,C1,..
Now I need to create Steet2 that holds row based data such as
A1-A1,B1-A2,C1-A3 and change the background color of A1,A2,A3, if the
data in A1,B1,C1 in Sheet1 is zero.
How can I do this?
Thanks,