Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting and formatting cells
I have an Excel workbook with 15 different worksheets in
it. Each sheet tracks grades for different classes. Each class has a different number of columns for entry, each with diffent formatting for that range of cells. When I move a record within my student list, I want to go to row 50 (which would be my template for that worksheet then copy only the formatting and formulas contained in row 50 and copy the formatting starting at the cell that is currently selected. Row 50 will have formatting and coloring so the end of the selection should stop at the cell prior to the unformatted cell in row 50) Example: On worksheet 12, row 50 contains formatting from column a to AB. Worksheet 13 has formtting from A to AG. If I am on worksheet 12 and I move data from row 6 to 14, after selecting A6 I would format A6 using only those cells that are formatted in row 50. Thank you very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying cell formatting when selecting from a list | Excel Discussion (Misc queries) | |||
By selecting cells adjacent to cells tally sheet | Excel Worksheet Functions | |||
Selecting & Formatting Columns w/ Merged Cells | New Users to Excel | |||
Selecting cells which do not meet a formatting criteria, and assigning a Range object to these. | Excel Programming | |||
Copying Formatting Without Selecting | Excel Programming |