Hey everyone, It's me again! With a complex problem to fix here.
I am using Excel 2003. I have a complex spreadsheet but I will try to explain it to the best of my abilities.
It is a calendar that has weeks along the top of it and then events (and tasks that must get done) on the side.
I am using conditional formatting:
=($B624-TODAY())<225 (Red)
=($B624-TODAY())<240 (Orange)
=($B624-TODAY())<255 (Yellow)
In a cell next to the event tasks. This conditional formatting style runs in each cell for multiple cells in the same COLUMN, but the last numbers (225,240,255) change according to the needs of the task.
Then I am also using conditional formatting:
=OR(ISNUMBER(SEARCH("xx",(AI623))))
=OR(ISNUMBER(SEARCH("xx",(AJ623:AK623))))
=OR(ISNUMBER(SEARCH("xx",(AL623:AM623))))
In a cell under each week. This conditional formatting style runs in each cell for mutiple cells in the same ROW, but the Letters (AI, AJ:AK, AL:AM) change according to the length of time I have set.
Hopefully this picture helps explain it a little more.
What I need to be able to do is to be able to create a "key" that has all the necessary months and formulas to go with them BUT each row needs to be able to be copied and pasted and have it pick up the correct target cell (which is a date).
Is there anyway to do this? I am at a loss here and would certainly appreciate any help!
I am using Excel 2003. I have a complex spreadsheet but I will try to explain it to the best of my abilities.
It is a calendar that has weeks along the top of it and then events (and tasks that must get done) on the side.
I am using conditional formatting:
=($B624-TODAY())<225 (Red)
=($B624-TODAY())<240 (Orange)
=($B624-TODAY())<255 (Yellow)
In a cell next to the event tasks. This conditional formatting style runs in each cell for multiple cells in the same COLUMN, but the last numbers (225,240,255) change according to the needs of the task.
Then I am also using conditional formatting:
=OR(ISNUMBER(SEARCH("xx",(AI623))))
=OR(ISNUMBER(SEARCH("xx",(AJ623:AK623))))
=OR(ISNUMBER(SEARCH("xx",(AL623:AM623))))
In a cell under each week. This conditional formatting style runs in each cell for mutiple cells in the same ROW, but the Letters (AI, AJ:AK, AL:AM) change according to the length of time I have set.
Hopefully this picture helps explain it a little more.
What I need to be able to do is to be able to create a "key" that has all the necessary months and formulas to go with them BUT each row needs to be able to be copied and pasted and have it pick up the correct target cell (which is a date).
Is there anyway to do this? I am at a loss here and would certainly appreciate any help!
