Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Cell range based on color of cell to existing formula
I'm using Excell XP 2002, Spread sheet is set up as followed
Past Due Date Total # Past Due, Past Due Date, Total # Past Due Grand Total 12/12/2001 1 12/12/2002 3 4 I have a maco that auto insets a Past Due Date and Total, but I am so stuck on how to add the new column of total # past due, the date columns are colored in a yellow. Each Time I add two new columns I need to have the grand total formula updated with the new total#past due column #, Help, please |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Cell range based on color of cell to existing formula
On Jul 30, 8:54 am, Jul in Ohio <Jul in
wrote: I'm using Excell XP 2002, Spread sheet is set up as followed Past Due Date Total # Past Due, Past Due Date, Total # Past Due Grand Total 12/12/2001 1 12/12/2002 3 4 I have a maco that auto insets a Past Due Date and Total, but I am so stuck on how to add the new column of total # past due, the date columns are colored in a yellow. Each Time I add two new columns I need to have the grand total formula updated with the new total#past due column #, Help, please Jul, Sorry I'm a little unclear as to what exactly your problem is. Could you post the code? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Cell range based on color of cell to existing formula
Can you post the macro. the problem look like you need specific code based
on the locations of your cells. I suspectt you need to use an offset and it will be esier to generate code if I saw the macro you are presently using. "Jul in Ohio" wrote: I'm using Excell XP 2002, Spread sheet is set up as followed Past Due Date Total # Past Due, Past Due Date, Total # Past Due Grand Total 12/12/2001 1 12/12/2002 3 4 I have a maco that auto insets a Past Due Date and Total, but I am so stuck on how to add the new column of total # past due, the date columns are colored in a yellow. Each Time I add two new columns I need to have the grand total formula updated with the new total#past due column #, Help, please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Color a Cell Based on a Range of Cells with Colors | Excel Worksheet Functions | |||
Formatting the color of a range of cells based on the value of one cell | Excel Worksheet Functions | |||
How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
change fill color of a range of cells based on color of a cell? | Excel Programming | |||
Define Range based on cell color | Excel Programming |