On 29 Sep 2005 17:08:07 -0700, "Floyd" wrote:

Thanks for all of the feedback.

My objection to using a VBA routine is this.

Let's say that I have data in D5:AA11. I would have a routine to read
a set of conditions that change with user input in D4:AA4. There are
sets of conditions in this range. Based on the conditions I am
creating a Gant chart by shading cells. So far there should not be any
problem with use a VBA subroutine.

I need to create 10 of these charts on at least 5 different worksheets.
If I had used a function, then I would have more flexibility than
using a subroutine.

Now I copy the cells above and paste in D20. I need to create a second
Gant chart. However, I now need to change the ranges that the
subroutine uses to determine whether conditions are met for the second
chart.

I realize that the subroutine option is viable. Right or wrong, it
seems to me that a function would be easier to implement.

I apologize for not being more explicit earlier.

Cheers.

If the conditional formatting on each worksheet is consistent within that
sheet, you could use an event triggered Sub tied to the particular worksheet.
Then, when data is changed (or entered) on that worksheet, the conditional
formatting for that sheet would be applied.
--ron