conditional formatting--need for visual basic?
Posted by Coline on January 18, 2002 5:10 PM
Hi, I have a worksheet in which I would like to do the following three things. Is visual basic necessary?
1. Repeat tables (including formulas & existing inputs from the previous table) for x times, based on the # of years of program operation (e.g., if a program were open for 5 years, there would be 5 tables. Table 2 = all inputs from table 1 + any changes, table 3 = all inputs from table 2 + any changes, etc.)
2. Maintain formulas used for calculations within each table.
3. Distinguish cells with formulas from those cells in which data have been entered manually by shading, etc.
I've accomplished the first two, but since I'm repeating tables, all cells currently have formulas in them. Any suggestions on how to accomplish this task with elegance, perhaps without learning VB?