From reading the form I have to admit I'm a little shy to ask these two questions and not feel a little... well, Dumb.
First Question: I have a set of data with column headers from A through XX. The data in each row has information about specific events over a large time frame. This data can be up to 4000 to 5000 rows of data. Specifically, I want to format the entire row if a value of greater than zero appears in the row within column T. I typically would go to the conditional formatting tab and create rule like =indirect("T"&ROW()) then establish the font color and font style. Once I apply to the entire sheet, everything looks great.
I'm using Excel 2007 and when I try to record this with the Macro record function I fail. It just doesn't work. Any thoughts?
Second question: while this set of data isn't nearly as long, I still struggle to visualize what the code would look like. Headers across the top contain column headers like client ID, name, address, and so on. I want to organize this info so that if multiple client names appear under the same client ID number it will pull the client data into a organized format down the left with the client ID in column A and column B has the names associated with the address, phone and so on underneath. Almost like a pivot table, but without the horizontal length you tend to get when you start adding lots of column values. My client data can have as much as 32 to 40 columns of information. This makes it hard when reading the data because you have to scroll to the right. Thoughts?
ti know I'm asking a lot and not providing screenshots and whatnot, but any thoughts would help. Which function would be best. Thank you.
First Question: I have a set of data with column headers from A through XX. The data in each row has information about specific events over a large time frame. This data can be up to 4000 to 5000 rows of data. Specifically, I want to format the entire row if a value of greater than zero appears in the row within column T. I typically would go to the conditional formatting tab and create rule like =indirect("T"&ROW()) then establish the font color and font style. Once I apply to the entire sheet, everything looks great.
I'm using Excel 2007 and when I try to record this with the Macro record function I fail. It just doesn't work. Any thoughts?
Second question: while this set of data isn't nearly as long, I still struggle to visualize what the code would look like. Headers across the top contain column headers like client ID, name, address, and so on. I want to organize this info so that if multiple client names appear under the same client ID number it will pull the client data into a organized format down the left with the client ID in column A and column B has the names associated with the address, phone and so on underneath. Almost like a pivot table, but without the horizontal length you tend to get when you start adding lots of column values. My client data can have as much as 32 to 40 columns of information. This makes it hard when reading the data because you have to scroll to the right. Thoughts?
ti know I'm asking a lot and not providing screenshots and whatnot, but any thoughts would help. Which function would be best. Thank you.
