View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jul in Ohio Jul in Ohio is offline
external usenet poster
 
Posts: 1
Default 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