no, i've got 2+ pipelines and i'd like to see the schedules for each laid out side by side for each day for two weeks. I've got a start date/time and end date/time and a product for each batch in each pipeline. I'd like it to look at worksheet1 say 'oh, it starts at x date and y time with this product so x,y cell gets colored orange. i've tried a couple of things but can't get it to run right....does that help? or make it more confusing? thanks!
It sounds like you want to conditional format (color them orange) to a range of cells....is that correct? Try format | Conditional formatting | then select the parameters fo the conditioning.....Am I missing something...? Do you want to do any totals, summaries of sorts?
silly me, i confused the computer. backtracked thru the small amount of code i'd done for the macro and found the prob. Anyone wants to see, e-mail me...i'll have the thing finished up this weekend. Thanks for your help, guys!
firstname.lastname@example.org put excel in your subject line if you would please...thanks! This message was edited by caytib on 2002-10-10 16:42